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.
N9107SMaul Errol T · Ocala, FLN9107TVaughan Lee E Jr · Philip, SDN91083Cahill Margaret G · Monroe, WAN9108DJ&P Aircraft LLC · Chugiak, AKN9108JCampbell Aircraft Restorations · London, KYN9108NMottinger Thomas A · Elizabeth, CON9109HJunior Coal Contracting Inc · Philipsburg, PAN9109LYellowbird LLC · Lititz, PAN9109QBurns Timothy M · Huntington, NYN910BJGary Boyce Aircraft Sales LLC · Shelbyville, TNN910BZJaspaer LLC · Anchorage, AKN910CCG/A Enterprise LLC · Elizabeth, CON910CPCivil Air Patrol Inc · Maxwell Afb, ALN910DKUpside Down Holdings LLC · Sherman Oaks, CAN910GSRobinson Nicholas Anthony · Westborough, MAN910KTAtp Aircraft 6 LLC · Wilmington, DEN910LCEuroaviation Inc Trustee · KematenN910MMMitchell James F · Bakersfield, CAN910MREcho Dynamics · La Mesa, CAN910PCOverton James Nowlin · Jacksonville, FLN910PFCertified Aviation LLC · Morristown, NJN910RLLong Reggie D · Newburgh, INN910SPMyers Benny R · Wasilla, AKN910TPMuhle Duayne K · Columbus, NEN91105Marr Brandon J · Monmouth, ORN91106Vantreese Farms Inc · Monte Vista, CON9110HSierra Aero LLC · Truckee, CAN9110JRkd Aviation Services Inc · Dallas, TXN9110UPiper Aircraft Inc · Vero Beach, FLN91117White Wings LLC · Anchorage, AKN9111DEmery Craig A · Wasilla, AKN9111KWdiaz Design Inc · Sunny Isles Beach, FLN9112JCmm Aviation LLC · Dover, FLN9112LRockey Bruce G · Bitely, MIN9112ZWalters Darren · Overland Park, KSN9113LZimin Carl E · Naknek, AKN9113VBarry Dustin Michael · Highland, ILN9114DMacair Aviation LLC · Xenia, OHN9114HRohwer Michael G Trustee · Tucson, AZN9114JRouss Charles F · Martinsburg, WVN9114LKeller Crop Surveillance LLC · Jonesboro, ARN9114TFlying Frog Aviation LLC · Palm City, FLN9114VTayl Number Aero LLC · Tontitown, ARN91150Itsacinch Inc · Mer Rouge, LAN91151Dagnon Scott R · Bozeman, MTN91154Ellingson Daniel E · Stuart, FLN9115DRoods Shawn R · Billings, MTN9115FMccaffree Andrea J · Shepherd, MTN9115LSavonen Stephen D · Ukiah, CAN9115QSoto Daniel-Rey · Smiths Station, AL
Back to AD 90-04-06 R1