AD 79-10-14 R1
Registered aircraft · 56,582
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N8897GShore Gerry · Inez, TXN8897STutak Peter B · Indianapolis, INFirst renewal noticeN8897TZweigle Zachary John · Redding, CAN8897URobison Stephen K · Frederick, MDN8898BThompson Christopher L · Durango, CON8898QNorthrop Grumman Systems Corp · El Segundo, CAN8898XSargent Matthew M · Glenwood, IAN8899BBradberry Mason P · Wichita Falls, TXN8899UYoon Kerry D · Franklin, TNN8899XJohnston Thomas D · Heyworth, ILN889BABarr Air Patrol LLC · Mesquite, TXN889ESDalissandro Michael Douglas · Hampton, NHN889JBeasley William D Sr Trustee · Big Lake, AKN889SDMedary Aviation LLC · Brookings, SDN889SLCunningham Richard Scott · Bedford, TXN889SPLeading Edge Aviation Inc · Spencer, IAN889TVD & P Gammill Farms · Marked Tree, ARN88ABBrown James L · Athens, ALN88BLBrewer Jim L · Loco, OKN88CZThree Holer LLC · Clayton, GAN88EStarlite Aviation Technologies LLC · Las Vegas, NVN88GMField Drew H · Dallas, TXN88HQAviation Capital Management LLC · San Jose, CAN88HSShields Edwin G · York, SCN88JAGc Aviation Services-1 LLC · Miamisburg, OHN88JDRichardson H L · Reform, ALN88KMTsukii Toshikazu · Tucson, AZN88KNRegistration Pending · Santa Rosa, CARegistration pendingN88KWDonnell James C · Crowville, LAN88MALowry Michael L · Chesterton, INN88MLProstar Flight Services LLC · Bozeman, MTN88NESorjen Inc · Indian Trail, NCN88NGBakke Dale W · Yankton, SDN88PBBraswell Jerrold W · Dillingham, AKN88PKGray Farms Inc · Albany, ORN88RBWarner David J · Englewood, OHN88RKJkg LLC · Idaho Falls, IDN88SQBank Of Utah Owner Trustee · Salt Lake City, UTN88SYYamashita Bruce · Honolulu, HIN88WTFlying L Aircraft Inc · Fort Denaud, FLN89005Singh Fiyaad · Ocoee, FLN8900BMathews Denis W · Quanah, TXN8900TSkyote LLC · Boise, IDN8901BThompson Douglas P Trustee · Alton Bay, NHN8901XHilde Justin · Statesboro, GAN8902BLeonard William L · Gettysburg, PAN8902TShort Steven A · Neillsville, WIN8902VFlycarolina LLC · Concord, NCN8903XGreene Bruce · Asheville, NCN8904VWaymaker Aviation LLC · Yukon, OK
Back to AD 79-10-14 R1