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.
N52497Hobar Geoffrey · Hoffman Estates, ILN5249DQuicksilver Skycraft LLC · Langley, WAN5249EAlexandria Aviation Inc · Alexandria, MNN5249JWhitgo LLC · Lucas, TXN5249RHigh Exposure Inc · Wilmington, DEFirst renewal noticeN5249TTri-Angle Aviation LLC · Henderson, KYN5249ZCreger Paul L Jr · Springport, MIN524BHHoot Brian D · Toledo, OHN524CWCentral Washington University · Ellensburg, WAN524DKCrane Doug M · Ellisville, MON524DRRegistered aircraftN524FLMoore Bruce W · Aledo, TXN524GSSilver Gary S · Farmington, UTN524HFBa Group LLC · Glastonbury, CTN524JASkyhawk Leasing LLC · Indianapolis, INN524JNFalley Patrick R · Encinitas, CAN524KWMorris Donald R · Carbondale, ILN524LVSchotanus Reed D · Daytona Beach, FLN524MFunny Penguin LLC · North Canton, OHN524MESmith Lester C Jr · Colleyville, TXN524NNielsen Marvin E Jr · Easton, MDN524PAm Utilities & Construction LLC · Palmhurst, TXN524PSOperchal Thomas · Marathon, FLN524PUMetro Aircraft Co · Bloomington, MNN524SCSpartan Education LLC · Tulsa, OKN524SJBorup Cory H · Orem, UTN524TCHalbrook Gorden E · Fleming Island, FLN524TLMoroni Nanette Teresa DBA · Orlando, FLN52501Freedom Works Consulting LLC · Louisville, KYN52505Petter John W · Wallis, TXN5250HPhilyaw Dale A · Lafayette, INN5250LAcharya Jagat P · Powell Butte, ORN5250TMedlaw Aviation LLC · Temple, TXN5250WJones Austin B · Suwanee, GAN52511Westfall Brent J · Three Lakes, WIN52516Christiansen Aviation LLC · Wilmington, DEN5251ERhinelander Flying Service Inc · Rhinelander, WIN5251HLuyster Roy A · Rochelle Park, NJN5251LRegistration Pending · Osage Beach, MORegistration pendingN5251RLong Island Aviators LLC · Seaford, NYN5251WAir Tech Enterprise LLC · Fitzgerald, GAN52521Rebel Aviation Inc · Liberty, MOFirst renewal noticeN52525Mulderink Allen F · Watertown, WIN5252TRunway Aviation Flight Training USA Corp · Rockwall, TXN5252WPayne Roger D · Tupelo, MSN5252XGlick Caleb A · Hillsville, VAN5252ZLamb Steve E · Big Bear City, CAN5253HBerry Milo A · Clarinda, IAN5253RAmerican Patrols Inc · Midland, TXN5253THart William · Johnson City, TN
Back to AD 90-04-06 R1