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.
N79475Registered aircraftN79477Shipley David L · Yates City, ILN79478Fusano Lisa A · La Crescenta, CAN79479Larue Mark C · Leander, TXN7947GStearman Field Aircraft Repair LLC · Benton, KSN7947PThorpe Jack · Raleigh, NCN79482Matacotta Ernest A · Marietta, GAN79488Nevels Steven D · Merritt Island, FLN79489Maisonet Gonzalez Hector W · Ocala, FLN7948NHayes William B · Saint Charles, MON7948WCruse Billy · North Bend, WAFirst renewal noticeN7949Thermoking Of Fargo & Isuzu Diesel Midwest · Fargo, NDN79493Bounds Trucking LLC · Faison, NCN79496Antique Aero Restorations LLC · Wilmington, DEN79498Gord James F · Sandwich, ILN79499Johnson Benjamin M · Monroe, WIN7949HButterfield Mike · Yakima, WAN7949NGuess-Slatosky Carrie · Randleman, NCN7949YReeve Howard E · Minot, NDN794AMeridian Aircraft LLC · Wilmington, DEN794AKFlying Dutchman LLC · Wasilla, AKN794BKMaxlines LLC · Fairfax, CAN794DSScholl Donald R · Abbeville, ALN79501Skyhawk Flying Club Inc · Omaha, NEN79506Allen Michelle E · Sebastopol, CAN7950GRotormate LLC · Royse City, TXN7950YKool Wings Leasing LLC · Indianapolis, INN79513Kalman Engineering Inc · Pekin, ILN79514Galaxy Aviation LLC · Nantucket, MAN7951F1world Aero LLC · Fort Meade, MDN7951WHerman Eric M · Hugo, MNN79526Evink Bradley D · North Branch, MNN79529Elliott Tina L · Tucson, AZN7952YHufnagel Christopher R Trustee · Santa Fe, NMN79531Newberry Tyler D · Clovis, CAN79533Eby William J · Sugar Grove, ILN7953CFox Victor Aircraft & Sales LLC · Lebanon, TNN7953WMcdaniel James D · Ortonville, MIN79540Funk Kathryn A · Rockledge, FLN79543Registration Pending · Manns Harbor, NCRegistration pendingN79546Diakonis Emmanuel W · Maumee, OHN79549Triad Aviation Academy LLC · Greensboro, NCN7954GNo Squawks LLC · Newcastle, CAN7954HSpidal Steven J Jr · Wasilla, AKN7954NW8s Enterprises LLC · Stillwater, OKN7954YBrausch Jon D · Huron, OHN79554Williams Kenneth J · Wasilla, AKN79558Silver Creek Aviation Services LLC · Snowflake, AZN7955HHudson Tom J · Kasilof, AKN7955NByrne Daryl K · Eagle, ID
Back to AD 90-04-06 R1