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.
N4536LFlorence Glen A · Shelby Township, MIN4536PPastuszenski Wayne · Austin, TXN4536RRoesler Robert D · Gordonsville, VAN4536TSherrod Roger F · Orlando, FLN4536VReese Thomas R · Marathon, FLN4536WAlger Michael · Umatilla, FLN4537NWeigand Robert A · Arcadia, FLN4537TRussell Brice S · Milton, MAN4537VAir Land And Sea Inc · Brewerton, NYN45385Steklenski Philip G · Olympia, WAN4538AHughes William L · Fort Worth, TXFirst renewal noticeN4538EGrasshopper Flying Club Inc · Poughkeepsie, NYN4538NN4538n LLC · Spring Lake, MIN4538QFlying V LLC · West Berlin, NJN4538TLarsen Jeffrey A · Spokane Valley, WAN4538XHicks Paul · Greenfield Center, NYN4539Raymer Michael K · Alma, ARN4539ASvenningsen Joshua J · Menomonie, WIN4539LTempin Alan Martyn · Woodstock, ILN4539PMolnar William J · Janesville, WIN4539SMask Rickey D · Denison, TXN4539VMinto Victoria L · Omak, WAN4539WWjordan & Co LLC · New Fairfield, CTN4539X4539x LLC · Saint John, INN453CMUniversity Of Central Missouri · Warrensburg, MON453HCRegistration Pending · Wasilla, AKRegistration pendingN453HZBerger Michael B · Washington Island, WIN453KBPashkevich Michele · Pine Bluff, ARN453PTHenrie Aviation LLC · Fairfield, NJN453SPUnited States Air Force Owner · Elmendorf Afb, AKN453TCCarrero Ian J · Memphis, TNN453YRPatterson John III · West Chester, OHN45406Tweten Scott D · Healdsburg, CAN45409Blair Dorothy A · Saginaw, MIN4540JDreyer Richard F · Springdale, ARN4540PKahn Stephen G · Morton, PAN4540RCase Herbert P · Wendell, NCN4540TMurray Clifford K · Brunswick, GAN4540ZBerdine Kenneth B · Arnoldsburg, WVN45412Diesel Aviation LLC · Millbrook, ALN45418Shartle Wesley P · Fredericksburg, PAN4541ASteward David F · Bartlett, TNN4541RBaker William D · Hyannis, NEN4541TUniversal Technical Institute Inc · Miramar, FLN4541XPeachtree Air LLC · Wilmington, DEN4542HJ Weston Phillips · West Jefferson, NCN4542JUht Christian M · Greenville, NYN4542LTabooma Flyers Inc · Vancouver, WAN4542NPollack Richard D · Santa Monica, CAN4542RBlue Skies Flying Club LLC · Painesville, OH
Back to AD 90-04-06 R1