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.
N915DDWest Michigan Aviation Academy · Grand Rapids, MIN915LCardinal Flying Corp · San Jose, CAN915LSBlack Bear Aviation LLC · Camden, DEN915NGWillard Theron K · Anchorage, AKN915SCI P M Ministries · Dufur, ORN915SPThin Air LLC · Hillsboro, WIN915TAAurora Aircraft LLC · Waterford, MIN915WBBordelon Warren P · Breaux Bridge, LAN915XKSk Aircraft LLC · Anchorage, AKN91602Kreikemeier Michael L · Belgrade, MTN91604Veeref LLC · Temecula, CAN91606Zoltak Aviation LLC · Perry, GAN91607Parreira Paul Jr · Dos Palos, CAN9160AAttitude Toys LLC · Wilmington, DEN9160BS & J Investments LLC · Sardis, MSN9160HTodd Media Inc · Tuscaloosa, ALN91614Hendrich Matthew G · Paso Robles, CAN9161ACabral Aviation LLC · Milton, WAN9161BLee Mark S · Grove, OKN9161CLatta Michael D · Auburn, WAN9161GBowling Gary L · Elk City, IDN9161HAir Athens LLC · Athens, GAN9161TMenagerie Enterprises Inc DBA · Denison, TXN91621Whitney Richard J · Mason City, ILN91626Tmstar Services LLC · Lewes, DEN9162BMedic Choppers LLC · Springdale, ARN9162HStratus Aviation LLC DBA · Vacaville, CAN9162UDag Arda Orcun · Mount Dora, FLN9163BWright Donald E · Greensboro, NCN9163GHayssen Arthur H · Sebastopol, CAN9164GZirjacks Winston L Jr · Gold River, CAN9164UUnderwood Callum M · Canton, GAN91651Cain Edward A · Pembroke, MAN91657Webster Max S · Dalton, PAN9165AAdams Harry J · Montgomery, TXN9165ULudwiczak Damian · Medina, OHN9165XShults Jerry G · Kingsland, TXN91661James One Seventeen LLC · Fairview, OKN91667Dennis Robert · Rosamond, CAN9166BWusterhausen Jerry L · Boynton Beach, FLN9166RSchwend Brian · Forsyth, MTN9166UKsnl Aero LLC · Shawnee, OKN91670Sierrahotellima LLC · Farmingdale, MEN91672Baldridge Steven J · Edmonds, WAN91673Martin Charles W · Twain Harte, CAN9167BAshley-Nye Johanna I · Graham, WAN9167CNew Garden Township · Landenberg, PAN9167GKgrd Aviators LLC · Greenwood, SCN9167UTobin Dustin J · Hesperia, CAN9167XRichard I French · Eatonville, WA
Back to AD 79-10-14 R1