AD 94-05-05 R1
Registered aircraft · 26,231
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.
N3177XBandy Suzanne M · Newport, ORN3178JBirmingham Pilot Academy LLC · Birmingham, ALN31797Graham Bruce M · Amarillo, TXN3179BLevin Lawrence E · North Pole, AKN3179JTri-County Flyers LLC · Morgantown, PAN317GTKatz Gary G · Louisville, KYN317TANoonan Thomas · Brick, NJN317TZHockin Aileen D · Hayden, CON3180ARoss Ranch & Livestock Co · Jordan, MTN31813Bsl Aviation Inc · Shreveport, LAN31815Kew Ralph E · Chantilly, VAN3181GFreiermuth Michael J Jr · Lodi, CAN3181XHart George · Roseville, CAN3182XHerrera Lizann · Sumner, WAN3183JRank Brian Andrew · Oxford, MIN3183NRocque Raymond F · Chattanooga, TNN3183XTrimble John Sr · Stone Mountain, GAN3184BCerisano Kevin · Trussville, ALN3184NSale Reported · Wichita, KSSale reportedN3184XSandlapper Aviation Of De · Bennington, VTN3185BThomas Coby M · Fairbanks, AKN3185NHarwell Gregory T · Lavonia, GAN3185XSanders John L · Sikeston, MON3186JHowenstein John G · Roseville, CAN3186XPanus Mark V · Hinsdale, NYN3187BRitchie Robert E · Centennial, CON3187EGriggs Thomas E Jr · Sherman, TXN3187JBrar Amuldeep S · Austin, TXN3188AReints Rydell J · Wasilla, AKN3188JFlight Time Builders Inc · Memphis, TNN3189VMunn Julian · Spring, TXN318MDunn Ronald G · Larwill, INN318RAllen Timothy J · East Kingston, NHN318SCMooney Frank X · Friendswood, TXN3190JSimon Mitchell B · Edison, NJN3190NRieser Ryan M · Portland, ORN3190XOso Air LLC · Missoula, MTN3191BMason Fred B · Waterford, OHN3191JPhillips Nicholas H · Mikana, WIN3191NDanford Michael S · Oshkosh, WIFirst renewal noticeN31925Woodhams Jonathon R · South Haven, MIN3192BKnutson David R · Girdwood, AKN3192JWestern Altitude LLC · Dayton, MTN3193AWeir Dale L · Kent, WAN3193JWebs James H · Alexander, KSFirst renewal noticeN3193NAas LLC · Ovid, MIN3193VFly Sky Ads LLC · Manalapan, NJN3194NSale Reported · Sacramento, CASale reportedN3194ZEvans Michael J · Woodstock, ILN3195AHoward Neil B · Gorin, MO
Back to AD 94-05-05 R1