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.
N778AASolo Aircraft Rental LLC · Farmingdale, NYN778CPCivil Air Patrol · Maxwell Afb, ALN778CWGarbati Thomas Jr · Waterford, CTN778EMHorizon Dreams LLC · Homer, GAN778RDKilo Golf Aviation LLC · St Simons Island, GAN778SATextron Aviation Inc · Wichita, KSN778VKPuerto Rico Management Services Inc · Coral Gables, FLN7790AHreshchyshyn Marta · Eagle River, AKN7790EScheall Daniel C Sr Trustee · Newport, ORN7790TAviation Trade Inc · Castroville, TXN7790UPlane Fun Inc Tr Trustee · Snellville, GAN7791H2 Aviation LLC · Middlebury, INN7791CRohlfing Frederic L · Kirkwood, MON7791TVintage Aero Aviation LLC · Baldwin Park, CAN7791UHall Richard C Jr · Benton, KYFirst renewal noticeN7791XCarson Roy K · Prescott Valley, AZN7792FBas Part Sales LLC · Greeley, CON7792KStoor Danny W · Fountain Hills, AZN7792TFrench Rodney A · Warsaw, INN7792UOso Air LLC · Missoula, MTN7792XNorthern Light Aviation LLC · North Waterboro, MEN7794EMagnuson Steven M · Modesto, CAN7794FWhitman Larry C · Hinesville, GAN7794UFlying Colors Airparts Inc · Leesburg, FLN7794XQuantum Edge Aviation Co · Boulder, CON7795TJim Air Inc · Wilmington, DEN7795XMcclure Kyle · Elbert, CON7796FLucarelli David L · Moncks Corner, SCN7796UDemaagd Ross E · Middleville, MIN7796XParnello Nick · Rockford, ILN7797ERegistration Pending · Kingsford, MIRegistration pendingN7797TDanforth Lawrence P · Flushing, MIN7797UHutchison Ryan A · Etiwanda, CAN7798EPnwav8r LLC · Seattle, WAN7798NGebhard John M · Hartland, WIN7798TCessna Aces LLC · Metairie, LAN7798USmythe Carl D · Tulsa, OKN7799FGeese Douglas A · Churubusco, INN779JABaumgart John · Nashville, TNN779MDSchodt Robert E Jr · Crewe, VAN779PTMacon Air LLC · Franklin, NCN779SATextron Aviation Inc · Wichita, KSN779SPPreferco LLC · Fargo, NDN779TCChesire Raphael John · Los Lunas, NMN779TMHilpert Robert M · Chapmansboro, TNN77APNelson Jeffrey R · Lebanon, OHN77AVHodge Dominic V · Anchorage, AKN77CKRaiz Coaching LLC · Fort Worth, TXN77CMRegistered aircraftN77CRVolatile Aero Ventures LLC · Boulder City, NV
Back to AD 79-10-14 R1