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.
N48440Hillsboro Aero Academy LLC · Hillsboro, ORN48443Christian James B · Peyton, CON4844EGroves Jamie L · Wasilla, AKN4844FKnightair Enterprises LLC · Caro, MIFirst renewal noticeN4844JSkoglun Eric W · Cashmere, WAN4844LHoover Liston LLC · Riverton, UTN4844TKings Wings LLC · East Wenatchee, WAN4844ZRegistered aircraftN4845AParenteau William · Maple Grove, MNN4845GNation Linda S · Sanford, FLN4845JL&J Aviation Inc · Atwater, CAN4845SSt Cloud Flying Group LLC · Richmond, MNN4846GNavy Annapolis Flight Center Inc · Edgewater, MDN4846JMiehle Arthur R · Villa Park, ILN4846LCoggins Beau · Alpine, TXN4846TChurchill Scott W · Le Sueur, MNN4847BCrossbrook LLC · Willoughby, OHN4847GFlying Daze · Batavia, OHN4847LKulwicki Gary Andrew · Seffner, FLN4847TKempton Larry G Jr · Grand Junction, CON48481Oklahoma State University · Stillwater, OKN4849AVeblen Raak · Auburn, CAN4849DN4849d LLC · North Logan, UTN4849LHummingbird Aviation LLC · Columbus, INN4849ZSwope William T · Georgetown, OHN484ACReist David A · Mount Joy, PAN484BLBlue Line Aviation LLC · Smithfield, NCN484CNew Tricks LLC · New Castle, NHN484DBRyan Matthew J · Green Valley, CAN484DHRaincross Aviation Services Inc · Wilmington, DEN484ERWisconsin Aviation-Four Lakes Inc · Madison, WIN484FLSmith Stephen A · Erwinna, PAN484JWAims Community College · Greeley, CON484MSuper Bee LLC · Lino Lakes, MNN484NDUnd Aerospace Foundation · Grand Forks, NDN484PPrickett Jonathan L · Austin, TXN484VMLake John K · Park City, UTN48500R&R Aero Services LLC · Eden Prairie, MNN4850BRoehrig James R Jr · Indianapolis, INN4850EGibson Timothy A · Frankfort, KYN4850GPeters Walter C · Rockford, ILN4850HGreen Airport Development Corp · Kemah, TXN4850LUpper Airway Aviation LLC · Sonora, CAN4851BCode Supplies Inc · Lakeland, TNN4851GEye Candy Aviation LLC · Jacksonville, FLN4851LCherokee Flyers LLC · Randolph, WIN4851TWillis Gary B · Willis, TXN4851ZNorris Randal E · Cambridge, KSN48521Hillsboro Aero Academy LLC · Hillsboro, ORN4852AHanrahan Andrew D · Soldotna, AK
Back to AD 90-04-06 R1