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.
N592DJFandango Ranch Operating Co Inc · Anacortes, WAN592FLGrey Rose Air LLC · Edenton, NCN592KAtp Aircraft 3 LLC · Wilmington, DEN592MBIngle Allen B · Goldsboro, NCN592NDUnd Aerospace Foundation · Grand Forks, NDN592RJWood Roger E · Waxhaw, NCN592RSProbst Danny R · Nokomis, ILN592SExperimental Aircraft Assoc Portland Chap 105 · Canby, ORN592SCN592sc LLC · Inola, OKN592ZHorton Michael D · Vernal, UTN5930USplendid Air Leasing LLC · Dover, DEN5930WGraham James C Co-Trustee · Bellville, OHN5930ZBrue Peter Gary · Cedar Rapids, IAN5931DStone Robert K · Piney Flats, TNN5931LLuft Aviation Inc · Wilmington, DEN5931UJ And H Aircraft Leasing Inc · Palmyra, PAN5932Autry Marbella A · Montrose, CON5932FWingin' It Aviation LLC · Glendale, CAN5932URegistration Pending · Bulverde, TXRegistration pendingN5932WSchaaf Rodney B · Bowman, NDN5933DHoward Trent R · Mandan, NDN5933QDonaldson Lucas P · Owyhee, NVN5934DBalsley Matthew G · Rowlett, TXN5934HAlden Aviation Management LLC · New Smyrna Beach, FLN5934VLuvsflying Flight Training LLC · Staten Island, NYN5934WDear Stephen R · Pioneer, CAN5934ZNew Daniel A · Deming, WAN59359Dingus Robert O L · Mount Perry, OHN5935PDaniel Hardy L Jr · Derby, KSN59369Stewart Michael W · Snellville, GAN5936DSchreiber Faith E · Valparaiso, INN5936QEllis Robert L · Columbus, OHN5936ZMeulenberg Jacobus M J · Schenevus, NYN5937GD'Arge Ranyon Wc · Wilson, WYN5937HFrasier Samuel R · Archer, FLN5937PTindall Michael C · Granite City, ILN5937QPospicil John A · Huntsville, ALN5937WMikesell Lloyd L · Kokomo, INN5937ZFurman Maximillian · Barnum, MNN5938LMidland Avionics LLC · Louisville, KYN5938QNeely Eric R · Seagoville, TXN5938ULame Duck Aviation LLC · Leesburg, INN5938WDewald Joseph L · Fort Wayne, INN5939WPhillips Morris · Decatur, GAN593ASwift Harvey G · Clinton, ARN593ACHomelvig John D · Bismarck, NDN593AMSandpiper Aircraft LLC · Wilmington, DEN593FLEmpire Aviators LLC · Long Island City, NYN593NDChristiansen Aviation LLC · Wilmington, DEN593SCSpartan Education LLC · Tulsa, OK
Back to AD 90-04-06 R1