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.
N5731ZTeterboro School Of Aeronautics Inc · Virginia Beach, VAN57320Resley Village Aero LLC · Carlton, TXN57322N57322 LLC · Spout Spring, VAN57324Richards Jeremy · Franklin, TNN57325Baker Ken C · Tehachapi, CAN5732DAerospace Center For Excellence Inc · Lakeland, FLN5732EWynn Josh · Bucyrus, OHN5732HWestern Antique Aeroplane & Automobile Museum · Hood River, ORN5732QAir Lords Inc · Middletown, DEN5732URabbe-Lee Tyler A · Minden, NEN57331Jmj Aviation LLC · Kalispell, MTN57335N57335 LLC · Churchville, PAN57336Wolfe Roark · Flagstaff, AZN57338Meyer Jerry W · Conway, ARN5733FVazquez Vega Jossel · Vega Baja, PRN5733PStrattner Brian J · Chesapeake, VAN5733QBlue Skies Flying Club · Burien, WAN5733UBerkshire Aviation Enterprises LLC · Great Barrington, MAN57343Arrow Plane Inc · Chapel Hill, NCN5734UPiepenbrink Stephen J · Wichita, KSN57350G F Aviation Inc · Miramar, FLN57352Dewalt Colt Aerospace LLC · Logan, OHN57353Registration Pending · Hollister, MORegistration pendingN57358Farnsworth Philo L Trustee · Dunes City, ORN5735PPlanecrazyd LLC · Portal, GAN5735QBeler Arnold Ray II · Redlands, CAN5735WMorahan Mark A · Sandusky, OHFirst renewal noticeN5735ZCrouch Michael G · Brazoria, TXN57360Ranuio Julie V · Ramona, CAN57361Janusz Mika · Phoenix, AZN57364Fit Fliers LLC · Worcester, MAN57369Fahmy Bishoy · Fraser, MIN5736HEdwards Stephen L Trustee · Wasilla, AKN5736QWard Troy · Odessa, TXN5736UWunder Bernard A · Lusby, MDN5736WTime Flyer LLC · Kalispell, MTN5736ZMiller Andy D · Marana, AZN57370Nj Aviation LLC · Forest, VAN57371Morgan H Owen · Windsor, CON57378Darling Darrin D · Palm Desert, CAN57379Faison Alphonso Trustee · Gardena, CAN5737QBross Stephen W · Burke, VAN5737UStebbins A C · Tacoma, WAN5737WUltimate Airparts LLC · Strasburg, VAN57383Dalley Robert C · Waldron, INN57385Victor Foxtrot LLC · Scott City, KSN57386Arair LLC · Kindred, NDN5738HWalker Scott E · Largo, FLN5738LRosche Henry III · Loveland, OHN5738QGuillen Gregorio J · Lopatcong, NJ
Back to AD 90-04-06 R1