AD 90-06-13
Registered aircraft · 1,827
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-06-13')
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-06-13')
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-06-13') 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-06-13') 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.
N476LCL-3 Is LLC · Kalispell, MTN476RSK & M Industrial LLC · Gladstone, MIN477JMBehrens Aircraft Leasing LLC · Waukesha, WIN477LCPremier Aircraft Trading Service Inc · Lewes, DEN478PAMerlin One Aircraft LLC · San Antonio, TXN47ANLagoinha Orlando Church Inc · Orlando, FLN47NMMooch Aire LLC · Anchorage, AKN47PWWelkin Aviation LLC · Beaver, WVN480RLBaseload Realty LLC · Corpus Christi, TXN484MMN484mm LLC · Amarillo, TXN485KBravo Hotel LLC · Lewes, DEN488SBJ&P Aviation LLC · Jasper, ALN48BVTrn Aviation LLC · Lewes, DEFirst renewal noticeN48CVAviation Trust Co LLC Trustee · Oklahoma City, OKN48FWLucas Oil Products DBA Lucas Cattle Co · Indianapolis, INN48KHAirshair LLC · Oak Creek, WIN492CGSwan Aviation LLC · Hattiesburg, MSN494GPAerotrust Services Corp Trustee · Wilmington, DEN494MAKing Lenny LLC · Fairview Park, OHN495CMAbove & Beyond Aviation Inc · Anchorage, AKN496JHN496jh LLC · Clovis, NMN497PFBravo Air LLC · Sellersburg, INN497RBAircraft Registration Inc Trustee · KematenN498CSMmu-Cit-Aviation LLC · West Orange, NJN499EMPhysicians Air Transport LLC · Hot Springs, ARN499RCCentral Virginia Aviation Inc · Petersburg, VAN49DKKts Holdings LLC · Elk Grove Village, ILN49FBFlying Bullet LLC · Grand Island, NEN49KCBeech Transportation Inc · Eden Prairie, MNN49KWJet Air Inc · Iowa City, IAN49LDMckee Foods Transporation LLC · Collegedale, TNN49LLSilver Wing Aviation LLC · Wilmington, DEN49UN49u LLC · Forest, VAN4ATGifford David K · Newton, MAN4QNLabutte LLC · Dearborn, MIN4TLMorningstar Aviation II Inc · Wilmington, DEN4TMJtm Ranches Equipment LLC · Dallas, TXN4ZLFlying 5 Llcf · Johnson City, TNN500CRElite Medical Air Transport LLC · El Paso, TXN500FRInterstellar Air LLC · Gainesville, FLN500FZDb N941jp LLC · Largo, FLN500UJMmi Air LLC · Bakersfield, CAN500ZBFregata Systems LLC · Saint Louis, MON501BZN501bz LLC · Boca Raton, FLN501EBPrecision Holdings LLC · Kimberly, IDN501GGN501gg LLC · Pasco, WAN501HKBam Aviation LLC · Baton Rouge, LAN501JGChallenger Aircraft Charters LLC · Newport Beach, CAN502APJbjp Capital Holdings LLC · Newark, DEN503JMDls Aviation LLC · Gilmer, TX
Back to AD 90-06-13