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.
N4559LAirtime Aviation Inc · Tulsa, OKN4559RCavu Flight LLC · Simpsonville, SCN4559TLeek Aviation LLC · Wilmington, DEN4559XJlp Flying LLC · Clewiston, FLN455ADMoghis Edgar C · Redwood City, CAN455AFGlacier Bay Aviation LLC · Fayetteville, GAN455BLPiper Aircraft Inc · Vero Beach, FLN455DDBailey Steven S · Ottawa, KSN455ETLakes Aircraft Inc. · Maumee, OHN455EZVan Every Jason E · Cleburne, TXN455FLFisher Jeffrey D · Omaha, NEN455GBBrs Leasing Inc · Wilmington, DEN455HFlying 20 Club Inc · Newtown, CTN455JIsler Jerry L · Donalsonville, GAN455LPhoenix East Aviation LLC · Daytona Beach, FLN455LBBaker Air Service LLC · Hahira, GAN455RTSouthern Genesis Aero LLC · Midland City, ALN455TASurles Gregory Taylor · Emerald Isle, NCN4560YCleveland William B III · Canal Fulton, OHN4561XAir Bhnb LLC · Statesboro, GAN4562RMcclure Richard A · Victoria, TXN4562TSellers Kelly A · Crossville, TNN4562XVenture West LLC · Mesa, AZN4563JPilling Ian M · Bonita, CAN4564FStern Aviation Inc · N Fort Myers, FLN4564ZJones Brad · Oak Hill, FLN4565AGriswold Joshua M · Wasilla, AKN4565FHughey Charles A Jr · Oak Ridge, TNN4565RHenderson Javier · Raleigh, NCN4565TSchendel Daryl R · Barstow, CAN4566JDifilippo Antonio O · Spring Church, PAN4566RMedia Stew LLC · Carson City, NVN4566WBoling Kyle C · Oak Hill, FLN4566XZihala William · North Little Rock, ARN4566ZPackett Roger L · Yachats, ORN45677Davidson Christopher Scott · Friant, CAN4567ADonovan Timothy P · Wichita Falls, TXN4567HFox Leo B · Lancaster, MON4567TPhoenix East Aviation LLC · Daytona Beach, FLN4568ABartlett Michael W · Barron, WIN4568FWings Over Texas Holdings LLC · Denton, TXN4568QMeacham Barry J · Glasgow, KYN4568RChuss Edward J · Metamora, MIN4569CReese Brandon A · Bend, ORN4569HPowell Randy N Trustee · Elko, NVN4569KJts Aircraft LLC · Rock Hill, SCN4569MEllis Wendell Kirk · Gakona, AKN4569RNoco Flying Club LLC · Fort Collins, CON4569VDittmann William H Jr · Palmetto, FLN4569XSequoias David O · Waxhaw, NC
Back to AD 90-04-06 R1