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.
N75ALTeebagy Steven C · Wellington, FLN75ARRegistered aircraftN75BFScussel Edward D · Albuquerque, NMN75BPPearce William R · Grants Pass, ORN75CEInternational Air Services Inc Trustee · Carson City, NVN75CMLowe Kenneth W · Sea Island, GAN75DFShelley Michael D · Murfreesboro, TNN75ECMaxson Phillip W · Green Cove Springs, FLN75ELTipton Capital LLC · Tulsa, OKN75ERFaulkner John · Urbana, OHN75GDCurren Scott N · Prospect, OHN75GPCross Colton · Allons, TNN75GSBright Sky LLC · Orwigsburg, PAN75HDMorton Michael E · Hickory, NCN75HUAviat Aircraft Inc · Afton, WYN75JADomenick James V · Placitas, NMN75JGWhisenant Roy H II · Poway, CAN75JWCompher Charles D · Berryville, VAN75JZAcv Group LLC · Mckinleyville, CAN75KAmra Nabil W · Chaska, MNN75KAN75ka LLC · Fort Washington, MDN75KJSeiter Gene G · Pleasant View, TNN75KRRoss Kevin · Granbury, TXN75MMDonney Tom J · Sturgis, SDN75MWJenkins George M · Wayne, PAN75NCRegistered aircraftN75NSJohnson Dale B · Steele, NDN75PAMadrid Michael J · Lompoc, CAN75PLMccombs John W · Fairfax, VAN75SDVimco N75sd LLC · El Paso, TXN75SEJansen Adam Roger · Sunnyvale, CAN75TCMorales Luis · Florence, ORN75TDMcmonagle Donald R · Westcliffe, CON75TJSantos Jorge · Shafter, CAN75UTSkyward Solutions Inc · Lewes, DEN75VEFord Randy L · Tucson, AZFirst renewal noticeN75VYRevell Ricki A Trustee · Monument, CON75WRIngram William R Trustee · San Diego, CAN75XCPenridge Aviation LLC · Portland, ORN7600DMangos Charles A · Rochester, NYN7600FGiles Forrest D · Springtown, TXN7600VRegistration Pending · Phillipsburg, KSRegistration pendingN7600WWeigley Kasey Jo · Graham, WAN7600YSchell Joseph H · Granbury, TXN76015Aldea Aviation Partners LLC · Encino, CAN76016Cape Fear Aviation Maintenance LLC · Fayetteville, NCFirst renewal noticeN76019Grimley Robert J · Palermo, NJN7601GWright Carl E · Conesville, OHN7601PVictory Holdings LLC · Anacortes, WAN7601URoads End Aero LLC · Erwinna, PA
Back to AD 90-04-06 R1