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.
N9816GRicker Harry K · Turner, MEN9817GLester Matthew J · Gouldsboro, MEN9817HBurcham Timothy Scott · Encinitas, CAN9817JDonahue Patrick J · Carriere, MSN98182Bena Christopher D Trustee · Wasilla, AKN98186Loyer Jeffrey W · Olympia, WAN98188Usda Forest Service Fepp · Columbia, SCN98189Kashmere Apartments LLC · Missouri City, TXN9818GGough Gregory · Emmett, IDN9818HFowler Raymond E · Smyrna, GAN9818XPlath James F · Davenport, NDN9819HStanley Aero Club Gastonia Inc · Belmont, NCN9819JFranco Louise A · El Cerrito, CAN981AKState Of Alaska · Anchorage, AKN981BCSilverhawk Aviation Academy LLC · Caldwell, IDN981BTPea-Wayman Flight LLC · Daytona Beach, FLN981CPCivil Air Patrol Inc · Maxwell Afb, ALN981MARed Rose Flight Tours LLC · Lancaster, PAN981MRJlove LLC · Vienna, VAN981RDSunrise Adventures LLC · Stillwater, MNN981SCCarter Brooks LLC · Kalispell, MTN981SFAtp Aircraft 1 LLC · Wilmington, DEN981SPLlp Leasing Group LLC · Lewes, DEN981TWKent Mark · Holden, MAN981WBFlying Fortress Of Swfl LLC · Fort Myers, FLN981WMFlying Fortress Of Swfl LLC · Fort Myers, FLN981WSNayrmarc LLC · Linden, MIN981WUEastern Kentucky University · Richmond, KYN98207Perkins Robert T · Anchorage, AKN9820HSeghieri Richard T · Santa Rosa, CAN9820JBenair LLC · Bonita Springs, FLN9820TSamson Robert C · Waterford, WIN98219White Jeffrey M · Carlsbad, CAN9821CN5965t LLC · Lehigh Acres, FLFirst renewal noticeN9821ERegistered aircraftN9821GGrubelich Mark C · Edgewood, NMN9821HDowning Darrell W · Drakesville, IAN9822ESample John A · Gonzales, TXN9822HPetsche Tim E · Meridian, IDN9822JSiskiyou Pacific Inc · Central Point, ORN9822VJohnson Mark W · Valrico, FLN9822XHultquist Daniel D · Anchorage, AKN9823LSilverhawk Aviation Academy LLC · Caldwell, IDN9823VSundance Aviation Inc · Moriarty, NMN9823XTop Hand Inc · Laurel, MTN9824HClimb LLC · Kalispell, MTN9824JBarksdale James Alan · Florence, ALN9824LSt Pete Aviation Services LLC · Saint Petersburg, FLN9824TNeufeld Dwayne A · Coeur D Alene, IDN9824VSafety In Motion Flight Center · Puyallup, WA
Back to AD 79-10-14 R1