AD 90-04-06 R1
Registered aircraft · 68,377
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-04-06-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-04-06-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-04-06-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-04-06-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.
N586FLAce Aircraft Leasing Inc · Nazareth, PAN586KAtp Aircraft 3 LLC · Wilmington, DEN586MAWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN586RHLugar Daniel A · St Helena Is, SCN586SRice James L · Mckinney, TXN587Plane Management LLC · Conroe, TXN58700Mile High Advertising Inc · Doylestown, PAN5870QScott Stewart · Columbia, MON5870UWhite Thomas A · Roanoke, TXN5871LSleeper James A · Middleburg, FLN5871QNeosho Investments LLC · Neosho, MON5871ZJohnson Nathan P · Rapid City, SDN58720International Air Services Inc Trustee · Carson City, NVN5872LMai David A · Chattanooga, TNN5872QAir Mods And Repair Inc · Robbinsville, NJN5872ZCollins James T · Blossvale, NYN5873QSternhagen Richard A · Friendship, WIN5873WPropst David A · Exchange, WVN5873ZSchramm Thomas L · South Rockwood, MIN5874DFeuerborn Ethan T · Boise, IDN5874UFlying Wright Aviation LLC · Henderson, NVN5874ZGodbey Patrick · St Simons Island, GAN5875HPresten Eric A · Vineburg, CAN5875UTews Jamie S · Greenville, WIN5875VCrew Michael A · Phoenix, AZN5875ZReed John F · Bemus Point, NYN5876DKirkendall James · N Richlnd Hls, TXN5876LWilson James · Bagwell, TXN5876U3shahs Aviation LLC · Temecula, CAN5876WKiss George C · Bangor, PAN5876ZDraper Scott · Rutland, VTN5877FFeldvary John · Jackson, MIN5877LFlyboys Aviation LLC · Sioux City, IAN5877QKenyon Alexandrea A · Costa Mesa, CAN5877VWest Keith W · Slatington, PAN5878ESouthern Aircraft Consultancy Inc Trustee · Casper, WYN5878GConner Norman V · Lakewood, WAN5878HDelaware Taildraggers LLC · Hancock, NYN5878LGomez Blanco Rafael · Lakewood, CAN5878UAlbright Jasper N · Raleigh, NCN5878WWorrell Wayne · Campbellsville, KYN5879HParlin Larrol L · Friday Harbor, WAN5879LN5879l LLC · Lewes, DEN5879UJacobs Levon Jr · Oak Hill, FLN587BHitterman James D · Metropolis, ILN587KAtp Aircraft 3 LLC · Wilmington, DEN587KBSwihart Painting LLC · Bolivar, MON587MALong Island Aviators LLC · Seaford, NYN587PAVan Hatten Michael Sr · Fairbanks, AKN587SPPinnacle Aviation Services Inc · Encinitas, CA
Back to AD 90-04-06 R1