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.
N8331GWhitley Jonathan K · Goldsboro, NCN8332GFlack Kevin S · Woolford, MDN8332UNeeley James L · Temecula, CAN8332XFlight Instruction Inc · Central City, NEN8333GInvestair LLC · Conway, ARN8334GAvcraft Inc · Columbus, NEFirst renewal noticeN8334THowe Danny · Camp Verde, AZN8334UBrown Matthew D · Hamptonville, NCN8334XBumgarner Tommy J · Stanley, NCN83355Krueger Steven A · Merrill, WIN8335AHaack Forrest · Wasilla, AKN8335TRegistration Pending · Greenleaf, WIRegistration pending, pending cancellationN8335UFaour Douglas M · Macon, GAN8336Lind Ronald C · Rainier, WAN83361Maynard Mark L · Kendall, NYN8336ANicholson Scott V · Kalamazoo, MIFirst renewal noticeN8336JGoat Rodeo Aviation LLC · Leesburg, INN8336MStarz Align Aviation LLC · Marshfield, WIN8336TBernal Sergio R · Buckeye, AZN8337GSkyline Aviation Inc · San Angelo, TXN8337JGeorge Downer Flyers LLC · Aliceville, ALN8337UHaeffner Christopher M · Saint Peters, MON8337XMckay Jim · Camden, TNN83387Goodwin Richard L · Northfield, MNN8338AWoodbury Forest P · Clarksville, TNN8338BSmitty172 LLC · Rockford, MIN8338TOhair Mitchell · Temecula, CAN8338USchnell Brothers Aviation LLC · Kalispell, MTN83391Abbe Thomas E · Wasilla, AKN8339BSmith Daniel B · Boonville, NCN8339UDrouet Douglas T · Eugene, ORN8340AWeyers William C · Grimes, IAN8340MBlake Larry Q · Suwanee, GAN8340TSopris Aviation LLC · Carbondale, CON83414Higgins Bennett P · Brewer, MEN8341BColeman Patrick D · Naperville, ILN8341MKab Aviation LLC · Cassopolis, MIN8341TSolum Edwin H · Spokane, WAN83426Smokovitz Joseph M · Tecumseh, MIN83427Registration Pending · Milton, TNRegistration pendingN8342BShelton Harold G · Christiansburg, VAN8342MStreeter Wyatt E · Hanford, CAN8342THoffmann John M · Applegate, MIN8342XRoberts Jeremy C · Winchester, OHN83436Milligan Reid D · Catawba, NCN8343MDuke Kay L · Darrouzett, TXN8343XHoward John D · Springfield, OHN8344GDonat Brandon L · Glendale, AZN8344TUrish Jay T · Mckinney, TXN83450Fish John F · Fayetteville, GA
Back to AD 94-05-05 R1