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.
N5080ZBrazil Joshua B · Omaha, NEN5081SDream Factory Aviation Inc · Henderson, NVN5081UKiloecho Aeronautics LLC · Tucson, AZN5081VWalker Gregory S · Gypsum, CON5081ZTech Mobile LLC · New Windsor, MDN50822Nyhus Sharon L · Harvey, NDN50826Bristol Bay Capital LLC · Watkins, CON5082GJala Tech Services LLC · Social Circle, GAN5082PShaw Jeryl V · Arcata, CAN5082RWings Over Texas Holdings LLC · Denton, TXN5082VMorton John W · El Segundo, CAN5082WAmeeti Robert Keith Trustee · Newport Beach, CAN5082ZHuddleston Anthony A · Knoxville, TNN50838Ansee LLC · Seattle, WAN5083KLoewen Wielhelm N · Presidio, TXN5083SRiser Air LLC · Stillwater, MNN5083VBarth Charles L · Pekin, ILN5083XFlytails LLC · Pace, MSFirst renewal noticeN5083ZMorell Patrick J · Byron Center, MIN5084MFabrizio Timothy · Oswego, ILN5084RBenham Eric T · Las Vegas, NVN5084WShouse Robert G · Owasso, OKN50854Fulton Lanny G · Spartanburg, SCN5085BAccelerated Aviation Instruction LLC · Owatonna, MNN5085KMartin Bach Aviation LLC · Cornelius, NCN5085SHall Thomas K · Beaufort, NCN5085VStumpf Douglas D · Aledo, TXN5085WMartin Marlin Ray Jr · Mabank, TXN5085XAzzalin Giorgio · Jacksonville, FLN5086EPark David W · Placentia, CAN5086RSafety In Motion Flight Center Inc · Puyallup, WAN5086SAero Air Inc · Salt Lake City, UTN5086XJacono Bruce L · Ramona, CAN5086ZRichards Curtis A · Troy, MON50873Bastien Peter M · Leesburg, VAN5087JSession Jason E · Higden, ARN5087KAir Capital Aviators Club · Wichita, KSN5087LGreen Airport Development Corp · Kemah, TXN5087WMcgough Craig N · Lancaster, TXN5087XRichardson Ethan Mack · Mount Pleasant, SCN5087YHansen Dewayne E · Fairbanks, AKN5088CMike Golf Holdings LLC · Pinellas Park, FLN5088KG & M Aircraft Inc · Wheat Ridge, CON5088LRichmor Aviation Inc · Hudson, NYN5088PKesser Gilbert M · Culpeper, VAN5088RGlacier Equipment LLC · Wasilla, AKN5088SSwaz Aviation LLC · Mesa, AZN5088TCox Stephen T · Fairborn, OHN5088XAmerican Aviation II LLC · Peyton, CON5088ZDavis Scott A · Bingham, NE
Back to AD 90-04-06 R1