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.
N447BBFerree William M · Stafford Springs, CTN447BDRegistration Pending · Columbia, KYRegistration pendingN447CTHowell Aviation LLC · Orlando, FLN447ESRegistered aircraftN447GHorn Rodney L · Friendswood, TXN447HHartz Paul · Lake Suzy, FLN447KSPoletto Danny A · Great Falls, MTN447PJones Thomas C · Friendswood, TXN447RMRocky Mountain College · Billings, MTN447TCOrange Sky LLC · Naples, FLN447TJMiller Timothy J · Hutchinson, MNN447WPWall Cameron J · Enid, OKN44800Schoppe Marc · Durham, NCN44802Page Aviation Services LLC · Fort Myers, FLN44805Gage Christopher · Truckee, CAN44806Nationwide Aviation LLC · Hudson Oaks, TXN4480HStatz Matthias Scott · Madison, WIN4480JGonzalez Guadalupe G · Atwater, CAN4480MBush Pilot Inc · Soldotna, AKN4480RSoutheastern Minnesota Flying Club Inc · Rochester, MNN4480SCook Christopher R · Manhattan, KSFirst renewal noticeN4480TSell Justin L · Lucerne, INN4480VOrtiz Albert Mike · Redondo Beach, CAN4480ZKalisz John B · Newhall, CAN44817Tokach Nicholas J · Hinckley, OHN4481EChambers David N · Cullman, ALN4481HMurray Gregory T · Napa, CAN4481JMusser Fred R · Severna Park, MDFirst renewal noticeN4481TValdes Eusebio · Miami, FLN4481XSpence Johnn · Apache Junction, AZN4481ZTucker Jason M · Wasilla, AKN44820Volar Corp · El Cajon, CAN44821Josselyn Jeffrey Scott · Midlothian, TXN4482EStaton Stephen D · Soldotna, AKN4482JWebe Properties LLC · Toledo, OHN4482MPapon Bruce G · Hardtner, KSN4482RBarxbar Aviation LLC · Mesa, AZN4482TIdeal Aviation LLC · Auburn, PAN44836Monadnock Aviation Inc · Keene, NHN4483JHelms Tate · Lake Charles, LAN4483MLorring David W · Fairbanks, AKN4483XBowers Gregory L · Greensboro, NCN4483ZWild Valley LLC · Wasilla, AKN44847Hill David F · Pembroke, MAN44848Flabob Airport LLC · Riverside, CAN4484XDelta Charlie Aviation LLC · Royal Palm Beach, FLN44855Marshall Xavier T · Carson, CAN44858Swaz Aviation LLC · Mesa, AZN4485ACrabb Philip E · Fairbanks, AKN4485FSaunders Raymond C III · Albuquerque, NM
Back to AD 90-04-06 R1