AD 90-13-01 R1
Registered aircraft · 1,150
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:90-13-01-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:90-13-01-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:90-13-01-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:90-13-01-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.
N283RLMarks Lloyd · Lafayette, LAN283XLThiel Air Care Inc · Chowchilla, CAN284CAOrgan Mountain Aviation Co LLC · Las Cruces, NMN285AEAir Evac Ems Inc · O Fallon, MON285RRBentley Drive LLC · Anchorage, AKN288AEAir Evac Ems Inc · O Fallon, MON289RLL&R Investment Partners LLC · Wilmington, DEN28EDWilliams Management & Consulting Inc · Anacoco, LAN28HTL&R Investment Partners LLC · Wilmington, DEN28LGZeliff Aviation LLC · Batavia, NYN28NAPremier Rotors LLC · Saint Martinville, LAN28UKOas2 LLC · Orlando, FLN290AEAir Evac Ems Inc · O Fallon, MON290LHLarson Helicopters LLC · Perham, MNN291SEzell Holdings LLC · Tucson, AZN2927WGulf Coast Helicopters Inc · Pearland, TXN2928WNova Helicopters Inc · Ashburn, VAN292AEAir Evac Ems Inc · O Fallon, MON292BHAbc Helicopters Inc · Jefferson, WIN293AEAir Evac Ems Inc · O Fallon, MON2944WTrinkle Avition LLC · Kingsburg, CAN2949WThiel Air Care Inc · Chowchilla, CAN295AEAir Evac Ems Inc · O Fallon, MON295CAChem-Air LLC · Shreveport, LAN2963WRegistered aircraftN-number assigned, not yet registeredN296AEAir Evac Ems Inc · O Fallon, MON296CCClayton County Police Department · Jonesboro, GAN297CAHelicopter Services Of Illinois LLC · Fisher, ILN2995WScotts Helicopter Services Inc · Le Sueur, MNN299AEAir Evac Ems Inc · O Fallon, MON299TBChemair Helicopters Inc · Jefferson, WIN29AEAir Evac Ems Inc · O Fallon, MON29HXHelicopter Express LLC · Chamblee, GAN29SHelicopters Inc · Cahokia, ILN2FGRmc Aviation LLC · Klamath Falls, ORN2NJNew Jersey State Police · Ewing, NJN301PDPeter Claire Ltd · GeorgetownN303AENorth Wind Aviation LLC · Cottage Grove, ORN304CHPerfect Agreements Leasing · Trabuco Canyon, CAN304MHBank Of Utah Trustee · Salt Lake City, UTN304PDCity Of Tucson Police Department · Tucson, AZN305CHGeco Inc · Wilmington, DEN305GLTickety Boo Consulting LLC · Whitefish, MTN305PDCity Of Tucson · Tucson, AZN306FWEgli Air Haul Inc · King Salmon, AKN306MHOlympic Jet Inc · Olympia, WAN306PDCity Of Tucson Police Department · Tucson, AZN306PHFinish Line Aviation LLC · Pembroke, NHN307RDHelicopter Services Of Illinois LLC · Fisher, ILN308LCLeon County Sheriffs Office · Tallahassee, FL
Back to AD 90-13-01 R1