AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N8452MHigh Flight LLC · Mount Pleasant, SCN8452UGibson Gregory I · Ivel, KYN8452XLas Gaviotas 409 LLC · Safford, AZN8453GBelue Gaythan D · Rogersville, ALN8453USappah Guy · Lusby, MDN8455JBentz Jack E · Huntington, WVN8455UOverton James D · Midland, TXN8455XRandall Jason L · Altus, OKN8456GAerial Perspective Inc · Fullerton, CAN8456JHam Russell W · Dike, TXN8457UMcclure Garnet J · Frankston, TXN8458JGp Aviation Leasing LLC · Hughson, CAN8458MChapman Brian P · Tulsa, OKN8458XBass Cindy S · Highlands Ranch, CON8459ULucci Giacinto A · Nashville, MIN84606Gregory Robert H · Glenwood, MNN84609Danielson David · Hibbing, MNN8460JHouston Juan D · Parkton, NCN8461DSilver Wings Flying Company LLC · Olympia, WAN8461GColbert Donald H · Tonasket, WAN8461JBailey Roger · Mccool, NEN8462XSmith Richard J · Jackson Springs, NCN84636Hare Leslie D · Merriman, NEN8463DQuist Scott D · Wasilla, AKN8463UDixon Steven M · Waynesboro, GAN84649Sikveland Beau D · Circle, MTN8464GWhite Sands Soaring Association Inc · Alamogordo, NMN8464MBarrineau Charles A · Palatka, FLN8464UOrmat Glenn · Wakarusa, INN8464XBistline Leland K · Fredonia, AZN8465GBeltz Darren S · Mattawan, MIN8465XMaynard Craig A · Dedham, MEN84669James Dennis · Pleasant Grove, CAN8466XEagle East Aviation Inc · North Andover, MAN8467USkyhawk Aviators LLC · Clayton, WAN8468UWarne Cory S · Granbury, TXN8469Glaser Arthur E · Crest Hill, ILN8469UTaylor Aviation Inc · Fort Benton, MTN8469XEagan Timothy H · Casa Grande, AZN846SCBouschor Denise · Stevensville, MTN846VWalker James E · Englewood, CON8470DRogers Bryan K · Anchorage, AKN8470UEagle Sky Patrol · Deadwood, SDN8471MSmith Trevor A · Justin, TXN8472GDirk Chantz M · Rapid City, SDN8472JEck Alan C · Henderson, MDN8473GDyck David · Sumner, TXN8473JKnighton Dennis · Headland, ALN8473MSpitzer Terry E · Kalona, IAN8474JHoward Linda Faye · Pink Hill, NC
Back to AD 94-05-05 R1