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.
N60605Croft Stanton W · Glenwood, NMN6060DHughes Truman C · Delta Junction, AKN6060WNilsen Daniel P · Holmes, NYN6061QThurston David H · Cincinnati, OHN6062ANelson Stephen H · Apple Valley, MNN6062LFoo Flyers LLC · Charlotte, NCN60634American Airpower Heritage Flying Mu · Dallas, TXN6063ELawrence Aviation LLC · Overland Park, KSN6063HHagerstown Flying Club · Williamsburg, INN6063QTaylor Alan M · Nekoosa, WIN6063UStotts Philip H · Capitola, CAN6064DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LAN6064LBohannon Jessica · Tomball, TXN6064QWilliams Rodney K · Stacy, MNN60658Euroaviation Inc · KematenN6065BStohr Martin C · Palm Coast, FLN6065HNoble Mark · Memphis, TNN6065QShick Douglas Todd · Chester, VAN6065WBeyond Aviation LLC · Jacksonville, FLN6066DDaily John F · Chugiak, AKN6066HFlaps Inc · Cincinnati, OHN6066LBrown Andy · Cypress, TXN6066NPacific Union College · Angwin, CAN6066QArmagost James C · Belton, TXN6066WAshpaugh Larry D · Hilltop Lakes, TXN6067NGustavson Allan R Jr · Tonopah, AZN6067QFrantz Joseph M · Gill, CON6068DThorn Blake A · Coupeville, WAN6068NVan Steenburgh Owen Christopher · Manitowoc, WIN6068PGear Down Hangar LLC · Phoenix, AZN6068QPressley Jerry · Morristown, TNN6068WRivera Jose · Spencer, WVFirst renewal noticeN6069FAmeriflyers Of Texas Inc · Addison, TXN606AAero Services Lc · Woods Cross, UTN606AGWhipple Marvin G · Pawnee Rock, KSN606APMacair Leasing LLC · Cocoa, FLN606BHWhite Montie Eugene Trustee · Hartsville, TNN606BJHickman Smith Dean John · Wilton, CAN606DEliason John P · Westcliffe, CON606DBBode Aviation Inc · Albuquerque, NMN606DMMangels Dale E · Bremerton, WAN606EAOakmere Leasing LLC · Norton Shores, MIN606ERHansen Justin L · St George, UTN606GSHillsboro Aero Academy LLC · Hillsboro, ORN606HSMyers Kenneth K · Rangely, CON606JPWilkins Jonathan · Woodridge, ILN606RFFitts Robert D · Independence, ORN606RVSuper D LLC · Nunn, CON606RWInternational Air Services Inc Trustee · Carson City, NVN606STStruck Jeffrey · Orange City, FL
Back to AD 90-04-06 R1