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.
N66425Biornstad John A · Big Lake, AKN6642ATundra Aviation Inc · Casselton, NDN6642FSomerset Flying Club · Basking Ridge, NJN6642GBurgmeier Peter W · North Vernon, INN6642SSellers Douglas D · Webster, NYN66431Neron II LLC · New Smyrna Beach, FLN66437Fluno John I · San Anselmo, CAN66439Mancini James N · Baltimore, MDN6643AMoore Michael J · Monroe, UTN6643FAyresouth Aviation Inc · Lithia Springs, GAN6643GStokes Patricia A · Nenana, AKFirst renewal noticeN66440Tenenboym Dennis Alexander · Pinellas Park, FLN66449Lindvig Thomas H · Williston, NDN6644GLive2flyfl Inc · Wilmington, DEN6644MSierra Lima Aviation LLC · Riverton, UTN6644TGreenfield Amanda J · Palo, IAN6644XCamous Daniel E · Miami, FLN66452Bedard Michael J Trustee · Madison, ALN66453Beaudry Phillip H · Newport, VTN66455Soendergaard Carsten · Aguila, AZN66459Amelia Reid Aviation LLC · San Jose, CAN6645TMcelroy James S Jr · Goddard, KSN6645XHarrison Joshua C Trustee · Huntington Beach, CAN66463Sikkema Romke P · Sebring, FLN66467Joe Dory Aviation LLC · Star, IDN66469Pirtle Sandra Rinehart · Winnsboro, TXN6646ERegistration Pending · Elbert, CORegistration pendingN6646GJenkinson Jeffery J · Montgomery, TXN6646HIowa Great Lakes Flyers Inc · Cheyenne, WYN6646TGillespie Justin M · Greensboro, NCN66471Nelson Travis E · Richland, MTN66472Bgmaviate LLC · Fairfax, VAN66478Mason John M · Gilbert, AZN66479Gardner John F · Lyons, NYFirst renewal noticeN6648EEverest Builders LLC · Cheyenne, WYN66494Graham Luke R · Rushville, NEN6649AShaw Frank Edward · Chestertown, NYN664AKWarren John · Homer, AKN664CAChristiansen Aviation LLC · Wilmington, DEN664CPTextron Aviation Inc · Wichita, KSN664EREmbry-Riddle Aeronautical University Inc · Prescott, AZN664PBThomas Anthony Robert Jr · Frederick, MDN66501Sanders Robert M · Youngsville, NCN66502Dewey Holdings LLC · Florence, ALN66506Scott John J · Arcadia, FLN66507Gozdowski Matthew D · Sylvania, OHN6650TAlumbaugh Bynum E · Jacksonville, FLN6650XMccloskey Brett E · Bexley, OHN66511Rawaero LLC · Warsaw, MON66516Mangon Aircraft Inc · Petaluma, CA
Back to AD 79-10-14 R1