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.
N5236MAri Ben Aviator Inc · Fort Pierce, FLN5236PCheyne Dewolfe · Cave Creek, AZN5236ZPlank Larry B · Perkins, OKN52371Hillsboro Aero Academy LLC · Hillsboro, ORN5237HSmith Richard D · Powell Butte, ORN5237LAir Sicko LLC · Albany, NYN5237TCavins Drew A · Jacksonville, FLN52384Jane LLC · Somerset, MAN5238KOptic Air LLC · Sioux Center, IAN5238LBreon Ryan L · Castroville, TXN5238NHuggins Charles R · Wasilla, AKN5238WMckibben Clint E · Lubbock, TXN5238ZMayer David J · Ingleside, ILN5239BGanim Rose B · Haydenville, MAN5239GOverturf Jason · Eureka, MON5239KSmoketown Flight Center LLC · Smoketown, PAN5239LWilson Ronald A · Elk Grove, CAN5239NDougherty Jennifer · Delta Junction, AKN5239TBrotherton Bradley T Trustee · Canby, ORN5239WG&M Aviation LLC · Woodward, OKN5239ZMellor Brad A · Spanish Fork, UTN523AAustin Donald T · Allegan, MIN523ABVector Air LLC · Erie, CON523AFVee Two Inc · Merritt Island, FLN523BCSaman Beshoy · Round Rock, TXN523BHColvin Buster · Big Cabin, OKN523CWCentral Washington University · Ellensburg, WAN523DPRegistered aircraftN523ERBagamaspad Alan M · Reseda, CAN523EZJackmond Matthew B · Olympia, WAN523FLOden Matthew E · Greenwood, SCN523JCJones Kenneth Harrison Jr · Converse, TXN523KPhillips Mason · Ogden, UTN523KCGarrett Ag Equipment Ltd · Premont, TXN523MWJoy Of Flight LLC · Kalispell, MTN523PUMetro Aircraft Co · Bloomington, MNN523SCBush Rider LLC · Erwinna, PAN52408Flory Jason E · Fremont, INN5240EWilson Brent A · Carmel, INN5240HSouthern Aircraft Consultancy Inc Trustee · Casper, WYN5240RRico Aviation Services Inc · Miami, FLN5240TRegistered aircraftN5240WVanni Steven J · Naples, FLN5240XPaulson Ricky R · Hudson, WIN5240ZReise Robert A · Meredith, NHN52417Eaton Roger C DBA · Vernon, NYN5241DSorbi Aviation Inc · El Cajon, CAN5241EBaldeo Kessho I · Bay Shore, NYN5241JDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN5241LFour One Lima Inc · Roanoke, VA
Back to AD 90-04-06 R1