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.
N4725DClover Park Technical College · Tacoma, WAN47261Future American Aviators LLC · Davie, FLN47268Jones Benn D · Bell, FLN4726BMurray Kenneth · Parkville, MDN4726JPurves Patrick W · Brooklyn Park, MNN4727D4 Leaf Clover Leasing LLC · Murrieta, CAN4727HJet & Rotor Aviation LLC · Sacramento, CAN4727JSindelar Kenneth L · Fremont, WIN4727LTeton Anesthesia Ltd · Batesville, ARN4727ZHartson William R · Petoskey, MIN4728JGlodo Gordon W · Grand Tower, ILN4729LCollinson Roger A · Concord, NCN4729ZSublogic Corp · Urbana, ILN472ACSwift Air LLC · Lebanon, TNN472AKAkima Logistics Services LLC · Colorado Springs, CON472ATAirmen Testing And Training Inc · Lantana, FLN472DDMeridian Aircraft LLC · Wilmington, DEN472JSTaylor Kirk B · Houston, TXN472KPB2 West Corp · Winona, MNN472MDSoutheast Anesthesia Plc · Mc Donald, TNN472NZeiler Richard Trustee · Thousand Oaks, CAN472PAHornsby Larry G DBA · Moody, ALN47303Skyhaven Airport Inc · Tunkhannock, PAN4730BPotter Jay O · Charlotte, NCN4730LMorris Robert W Jr · Owasso, OKN47319Detsch Andrew J · Berkeley, CAN4731FKaland Gary D Trustee · El Cajon, CAN4731JLandon Jeff · Quartz Hill, CAN4731ZLamb Steve E · Big Bear City, CAN47321Griffith Aviation Inc · Griffith, INN47323Danaha Jerry E · Diamond Bar, CAN47326Maury David · Winter Garden, FLN4732JN500tj LLC · Middletown, DEN4732LRaven Gang Flyers Corp · Wilmington, DEN4732VGeneral Aviation Support Corp · Rosamond, CAN47337Beatty William Keith · Lakeland, FLN4733DWycoff Shannon M · Baton Rouge, LAN47349Fox Two LLC · Camino, CAN4734ANewman Macy M · Plano, TXN4734JGeurink Jonathan E · Hudsonville, MIN4734LForsgren Lyle M · Oshkosh, WIN4734VShaw Logan · Redding, CAN47350Evanson Mark A · Wharton, TXN47352Hawes Robert Kevin · Alpharetta, GAN47353Star Mountain Aviation Inc · Hardy, VAFirst renewal noticeN47354Wings Over Texas Holdings LLC · Denton, TXN4735LGunter David R II · Lavonia, GAN4735ZDebold David A · Spring, TXN47367Swaz Aviation LLC · Mesa, AZN4736JOliver Darrin C · Ripley, OKFirst renewal notice
Back to AD 90-04-06 R1