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.
N8491QDry Bay Holdings LLC · Yakutat, AKN8491SOgrin Kirk V · Bigfork, MTN8491URegistration Pending · Garrettsville, OHRegistration pendingN8491XHeauser Mark · Grass Valley, CAN8491ZBoice Christopher T · Roseburg, ORN8492LCarey Thomas A · Carabaset Vly, MEN8492SFlight Testers LLC · Seattle, WAN8493LBriss David S Dmd · Somerset, NJN8493MValiair Lc Trustee · Casper, WYN8493XDavis Michael L · Rowland, NCN8494GReynolds Terry J · Phoenix, AZN8494LHess Garrett · Fullerton, CAN8494MCardinal Sg LLC · Mukilteo, WAN8494URieck Brian M · Junction, TXN8495GCorrigan John P · Denver, CON8495JParks Ryan Alan · Newcastle, WYN8495MCourtney Aviation LLC · Columbia, CAN8495TCullom Mitchell T · Anchorage, AKN8495XRomeoromeo Alpha LLC · Greensburg, INN8496QWord Forrest R Trustee · New Braunfels, TXN8496SOkon Randy W · Missoula, MTN8496UChandler Donald M · Alexandria, LAN8496XR & R Flight Services LLC · Orange Grove, TXN8496ZRegistered aircraftN8497GDeacon Jeffrey A · Battle Ground, WAN8497MWenatchee Valley Barnstormers LLC · Wenatchee, WAN8497URawlins Flying Club Inc · Rawlins, WYN8497XConnors James R · Manchester, MIN8498LWestern Slope Aviators LLC · Delta, CON8498XThompson Jason Edward · River Heights, UTN8499GRyan Richard E · Atlantic, IAN8499LKennedy Christopher S · Canton, ILN8499MCornale Michael J · Dwight, ILN8499SGraznak Timothy C · Greeley, CON8499TLewis Lawrence R · Newport, WAN8499XSkaggs Nathan H · Peebles, OHN849CPCivil Air Patrol · Maxwell Afb, ALN849KBoard Of Trustees Of Southern Illinois University · Carbondale, ILN849KSKansas State University · Salina, KSN849PAChristiansen Aviation LLC · Wilmington, DEN84ATJ Squared Enterprises Corp · Hendersonville, TNN84CWestern Summit Enterprises Inc · Pacoima, CAFirst renewal noticeN84CCBowman Gregory H · Wichita, KSN84DLAirplanes And Helicopters Of Oregon LLC · Sisters, ORN84DMGafni Tal · Scottsdale, AZN84EBas Part Sales LLC · Greeley, CON84EDAms Aviation LLC · Brashear, TXN84FFKoorenny Brian G · Clarkston, WAN84JK Diamond K Guest Ranch LLC · Republic, WAN84LCRegistered aircraft
Back to AD 79-10-14 R1