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.
N4343REndless Sky Aviation Inc · Syracuse, NYN4343TLeonard Alan W · Hiubee, MON4343WRhodes Stephen D · Hendersonville, NCN4343ZHood River County Sheriff'S Office · Hood River, ORN43448Warrior Partners LLC · Delphi, INN43449Blue Sky B&Rd LLC · Heber City, UTN4344AMccarthy James L · Anchorage, AKN4344HOstrowski Frederick J · Otsego, MNN4344MBales Jeffrey M · Greendale, WIN4344PAbele Benjamin · Lexington, NCN4344TSpiegel Carl E · Waterford, CTN4344ZLindley Douglas R · Nantucket, MAN43455Siskiyou Aero LLC · Ashland, ORN43456Parker Air LLC · Mobile, ALN4345BHamilton Justin M · Knightsen, CAN4345CAeroservice Aft Corp · Miami, FLN4345GG & M Aircraft Inc · Wheat Ridge, CON4345HChampaign Sharon · New Holstein, WIN4345JSkinner Gary L · Winchester, OHN4345MTice Robert M · Millinocket, MEN4345QNeptune Aviation Services Inc DBA · Missoula, MTN4345ZSimonson Daniel J · Loring, MTN43460Seals Wiley · Suitland, MDN4346ADeakyne Carl · Rehoboth Beach, DEN4346DLane Community College · Eugene, ORN4346FBohne Geoffrey C · Poway, CAN4346HStrickland Mark J · Arlington, TXN4346JVelthuis Remintyn · Fontana, CAN4346QCorrado Christian Blake · South Point, OHN4346RFlyhnz LLC · Oxford, NCN4346XFourwide Transportation LLC · Mcallen, TXN43474Mudhen Aviation LLC · Goldsboro, NCN4347DAviation Flight Services Inc · Cumming, GAN4347ECarver Lloyd · Snellville, GAN4347GPurdue Pilots Inc · West Lafayette, INN4347HKillian Regina · Prosper, TXN4347KPray Aviation Inc · Augusta, KSN43488Ravotti Air LLC · Leechburg, PAN4348FRegistered aircraftN4348NVodon Mark A · Ventura, CAN4348QStehouwer Todd J · Kentwood, MIN4348ZWilliams Reid G · Cantwell, AKN43493Henderson James A · Flomaton, ALN43496Hooper Alphus C · Deville, LAN4349FStriegel Jory D · Washington, DCN4349HEsparza George · Loves Park, ILN4349LParker Air LLC · Mobile, ALN4349MRupiper Nicholas J · Ankeny, IAN4349RVaughan James · Meansville, GAN4349TJrh Avgroup Inc · Satellite Beach, FL
Back to AD 90-04-06 R1