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.
N45315Taylor Caleb H Trustee · Rancho Santa Fe, CAN45319Dale Timothy · Simsbury, CTN4531FOneill Robert J · Rocklin, CAN4531HTerris Edward A · BucksN4531JQualitair LLC Trustee · MichelstadtN4531SMajors Flying Club · Greenville, TXN4531ZFelts Jacob I · Kalispell, MTN45322Alvord Scott Richard · Yorba Linda, CAN4532ARasmussen Duane T · Culbertson, MTN4532BSpeedbird Ventures LLC · Driftwood, TXN4532HAdvanced Flight Systems Inc · Canby, ORN4532JCohen Kyle Lee · Houston, TXN4532KFranklin Paul A · Independence, ORN4532MObrien James P · Mullen, NEN4532NSkytypers Inc DBA · Las Vegas, NVN4532PMorowitz Jeremy T · Greenwich, CTN4532RWherley Matthew J · Plato, MNN4532UAtlas Builders LLC · Valdosta, GAN4532WAbernathy Aviation LLC · Morristown, TNN4532XMarrs Daniel J · Red Wing, MNN45336Kelley Joshua S · Anchorage, AKN4533AMount David B · Fairbanks, AKN4533FHall Jonathan D · Allison Park, PAN4533PFoltz Jeffrey W · Richmond, TXN4533QBritton David L · Franklin, OHN4533WNoco Bluesky LLC · Loveland, CON4533ZDavis Taylor M · Doylestown, PAN45343Bobbish Charles G · Reston, VAN45344Adventure North Flying Service LLC · Baudette, MNN45349Wall Johan D · Brookston, TXN4534DOliver Larry C · Citrus Heights, CAN4534E34 Echo Group · Spring Branch, TXN4534HRevoir Scott R · Hastings, NYN4534JCartaya Lazaro C · Miami, FLN4534LBottem Lee T · Broken Arrow, OKN4534RDuwelius Charlotte Sue DBA · Hermiston, ORN4534TSunrise Aviation Inc · Ormond Beach, FLN4534VSammons Ryne William · Bargersville, INN4534X4534xray Flyers Ltd · Lima, OHN4534ZKay Bennie L · Brigham City, UTN45359Clapp Edwin G III · Fargo, NDN4535DFrancis Mark D · Holden Beach, NCN4535JMooney Executive Partnership · Kent, WAN4535LCratz33 LLC · Cincinnati, OHN4535TCrews Joseph G · Cleveland, MSN4535VSanders Aviation LLC · Boerne, TXN45362Morrow Rodney T · Yorktown, INN45367Christensen Robert T · Presho, SDN4536BHolsten Guy V · Mineral, VAN4536JSale Reported · Merrill, WISale reported
Back to AD 90-04-06 R1