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.
N78133Dancing Buffalo LLC · Shreveport, LAN78139Van Straten Patrick F · Shiocton, WIN7813AKvichak Lodge LLC · Anchorage, AKN7813FUp And Away Aviation LLC · Poughkeepsie, NYN7813NOtoole Kevin H · Logandale, NVN7813ZMainus Virginia L · Westfield, PAN78142Partyka Kenneth M · Circle Pines, MNN78144Kyzer Aviation Holdings LLC · Fort Mill, SCN7814GClayton Steve · San Anotonio, TXN7814XOsterhouse Timothy D · Kalamazoo, MIN7814ZVaughn Rex · Spur, TXN78158Hill Donald J · Godfrey, ILN7815DAviation Training LLC · Wilmington, DEN7815GNextgen Flight Academy Inc · Riverside, CAN7815XHearn Brian Franklin Trustee · Carrabelle, FLN78174Spencer Aviation Inc · Delaware, OHN78179Horgan Robert V Jr · Wolfeboro, NHN7817GBarnhard James L · Washington, DCN78180Gatewood Doris E · Stokesdale, NCN78182Ajayi Samuel O · Jacksonville, ARN78183Smolik Vincent C · Ponder, TXN78185Sankey Paul F · Colusa, CAN78186Johnson Gavin R · Othello, WAN7818AGeoterra Inc · Eugene, ORN7818BRitenour John C · Knoxville, TNN7818EHurlin Nicholas E · Newburyport, MAN7818GLippert Charles Phillip · Southwick, MAN7818VGlide Slope Aviation LLC · Flagstaff, AZN78190Prp Aviation LLC · Ocala, FLN78195Mishawaka Pilots Club Inc · Osceola, INN78197Allen County Regional Airport Authority · Lima, OHN7819ELinscott Jeffrey R · Boring, ORN7819GCre Aviation Holdings LLC · Ramona, CAN7819KCollins Brian D · Middlebury, VTN7819ULott Tyler · Kenneth City, FLN781BGVan Anda Aviation LLC · Apopka, FLN781CBMiller Charles Litle Trustee · Fresno, CAN781FMFmfa Inc · Wilmington, DEN781JAPhoenix East Aviation LLC · Daytona Beach, FLN781MCOster Kenneth W · Coarsegold, CAN781SAMeyers Terry E · Galesburg, NDN781SPJw Wings LLC · Midlothian, TXN78207Sherman Todd P · Collinsville, OKN7820UMorris Aviation LLC · Spring Hill, TNN7820XMassiel Galvan Grijalva Frida Trustee · Tucson, AZN7820ZBuckley Joseph L · Gulfport, MSN78215Alvarado Eduardo · Fayetteville, TXN78219Testa Christopher · Kennesaw, GAFirst renewal noticeN7821AKw Air LLC · Darlington, INN7821EOrvin Sanden Inc · Wyndmere, ND
Back to AD 79-10-14 R1