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.
N91680Kay Scott Aviation Insurance Inc · Reno, NVN9168AMatthews Jeff M · Conowingo, MDN9168BAverett Joseph B · Denham Springs, LAN9168GClark Byron · Olympia, WAN9168UC150 LLC · Gilbert, AZN91690Walker Curtis N · Phoenix, AZN91691Stumm Robert W · Cadott, WIN91699Caughlan Cody P · Santa Cruz, CAN9169CVajdos Robert C Jr · Louise, TXN9169GDodson International Parts Inc · Rantoul, KSN9169UVipperman Richard Madison Jr · Martinsville, VAN9169XAllen Air LLC · Fennville, MIN916ACYr-Aircraft Leasing LLC · Bethel, AKN916ATKdrd Holdings LLC · Texas City, TXN916AVLopez Virgilio D · Brookshire, TXN916BAMaya Aircraft Holdings LLC · Lee, NHN916BQ9k Air LLC · Newark, DEN916CLDolphin Sales Inc · Wilkes Barre, PAN916DFGasmire Charles · Frisco, TXN916ET9k Air LLC · Newark, DEN916FT9k Air LLC · Newark, DEN916GGSutton Aircraft Salvage LLC · Palmer, AKN916GW9k Air LLC · Newark, DEN916HT9k Air LLC · Newark, DEN916KTPelican Flight Training LLC · San Carlos, CAN916MABusch Brett · Stanford, MTN916MHHelmerich Jonathan D Jr · Tulsa, OKN916NT9k Air LLC · Newark, DEN916PBM & G Aircraft Management LLC · Aurora, ORN916PYBragg Kris M · Embden, MEN916QTElizabeth City State University · Elizabeth City, NCN916RR9k Air LLC · Newark, DEN916SEEiland James · Phenix City, ALN916TAAtp Aircraft 4 LLC · Wilmington, DEN916UT9k Air LLC · Newark, DEN916WCBarr Air Patrol LLC · Mesquite, TXN916WRPsl Surveys · Manassas, VAFirst renewal noticeN91705Gerbick Dean · Lena, ILN9170APasqualino Carolyn G · Ocala, FLN9170BRegistration Pending · Shohola, PARegistration pendingN91718Miklos Russ · Youngstown, OHN9171GKiehl Flying Service LLC · Winnett, MTN9171HSonday Terrance · Spring, TXN9171MCarbon 182 LLC · Montgomery, TXN9171TLangmuir Circulation LLC · Perkasie, PAN91721Scott Dennis E · Wake Forest, NCN91722Ken-Oh Transportation LLC · Porter, INN91726Kcsi Aerial Patrol Inc · Bakersfield, CAN9172AAndress Chad R · Casper, WYN9172CBolinger Dean R · Bend, OR
Back to AD 79-10-14 R1