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.
N8171DLueking Clyde F · Holdrege, NEN8171NOndrovic Rick · Belton, SCN8171YFaith Works Aviation LLC · Glenmoore, PAN8172Magrini Shawn P · Salem, OHN81723Aero Legacy Foundation · Basehor, KSN81729Bushroe Dennis J · Temperance, MIN8172CDrath Mark O · Reedsville, WIN8172NBeasley Michael Jeffrey · Dothan, ALN8172QFrost Aviation Services Inc · Las Cruces, NMN8172WMile High Advertising LLC · Dover, DEN8172YKline John C · Wolcottville, INN8172ZAverka Steven D · Sutton, MAN8173DAaa Flying Service Inc · Wellington, TXN8173ESky Equity LLC · Woodbury, MNN8173NJones Roy F · Benson, AZN8173WRoadrunner Flight School LLC · Farmington, NMN8173YAltitude Aviation Group LLC · Kissimmee, FLN81741Corsican Aviation LLC · Westfield, INN81749Friend Aircare Inc · Washington, PAN8174MFlight Time Builders Inc · Memphis, TNN8174WJeffers Coreen · Bellmawr, NJN8174YStansbury Todd V · Centennial, CON8175CYates Trucking Inc · Quartz Hill, CAN8175EHigh Planes Aviation LLC · Goodland, KSN8175HHowe Richard B · San Luis Obispo, CAN8176Lewandowski Mark J · Wilton, CAN8176CShaffer Glenn · Vinemont, ALN8176NPlane Doc LLC · Phoenix, AZN81771Skyfusion II LLC · Atlanta, GAN8177NAspiras Dionisio O Jr · Rosharon, TXN8177WDavis James Warren · Albemarle, NCN8179DGarza Jose R Jr · West Jordan, UTN8179HSam Air LLC · Daphne, ALN8179NFletcher William J · Mason, NHN8179THill Jason M · Bakersfield, CAN8179WLynch Gary L · Ocala, FLN817AAnderson Jennifer M · Biggs, CAN817ABHawaii Pacific Aviation Inc · Kailua Kona, HIN817ACCannon Air Force Base - Aero Club · Clovis, NMN817AKZweifel Brad · Palmer, AKN817BWWalker Baylor L · Big Spring, TXN817DHMastrangelo John A · Phoenix, AZN817FKSimply Living LLC · Fort Myers, FLN817GAtp Aircraft 9 LLC · Wilmington, DEN817HAIasco Flight Training Inc · Redding, CAN817HSMoore Stephen T · Ellensburg, WAN817JJenkins Jay T · Burnsville, MNN817JCCain Jerome M · Lincoln, MTN817JVRusyniak Anthony J · Syracuse, NYN817KCCrawford Michael R · Gainesville, GA
Back to AD 90-04-06 R1