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.
N680CDFly Mnt LLC · Glenview, ILN680DMGreen Daniel P · Westcliffe, CON680FLSchrimpf Robert · Batesville, INN680HWOmega 1 Corp · Middletown, DEN680LHChristiansen Aviation LLC · Wilmington, DEN680MAChristiansen Aviation LLC · Wilmington, DEN680NDMedary Aviation LLC · Brookings, SDN680PJAugust Aero LLC · Kalispell, MTN680PTWarbirds LLC · Scottsdale, AZN680SHSouthern Utah University · Cedar City, UTN680TFAir Fleet Holdings LLC · Addison, TXN680WWilkes Steven E · Wichita, KSN680XLipinski Glen E · Chandler, AZN6810DRawdon Robert C Jr · Hohenwald, TNN6810VMaxson Gerald M · Hawthorne, FLN6811Dinnerbell Farms LLC · Eden, WIN68111Murphy Frank · Thomasville, GAN68113Gogoplex LLC · Wilmington, DEFirst renewal noticeN6811HJohnson Larry P Jr · Waynesville, GAN6811JRodgers Byron D III · Alexandria, VAN6811KBashore Charles A · Madison, ALN6811NVan Koetsveld Ernst J · Alexandria, VAN6811PStewart Steven L · Campbellsburg, INN6811UColeman Ronald R · Walla Walla, WAN6811WKlaerner Donald John · Fredericksburg, TXN6812NGrandruitt Rory Allen · Wadena, MNN6812PBrownfield Bruce Stuart · Oak Park, CAN6812UAll Things Guns LLC · Westfield, WIN6812VMoita Robert Jimizez Jr · Templeton, CAN68137Wind Walker LLC · Tucson, AZN6813LKing Robert B · Sheridan, WYN6813UShelton Timothy · Salisbury, NCN6813VEastern Stearman Inc Trustee · Leesburg, VAN6813WRotor And Wing LLC · Tioga, NDN68141Erb William F · Oakdale, CAN6814BMensing John P · Country Club Hills, ILN6814HUniform Gulf Aviation LLC · Williamstown, NJN6814JTavzel Aviation LLC · Portland, INN6814NMckenna Terence M · Scotts Valley, CAN6814UGeorgescu Radu A · Louisville, KYN6815BCopper River Airmotive LLC · Copper Center, AKN6815VCardinal Jeffrey W · Santa Maria, CAN68165Dahmer Frank J · Micanopy, FLN68167Toms Annette M · Liberty, NCN6816AAtp Aircraft 8 LLC · Wilmington, DEN6816FQuality Aviation Inc · Faribault, MNN6816NHollis Leo D Jr · Bluffdale, UTN6816PElliott Patrick K Sr · North Bend, ORN6816UDo Cong · York, PAN6816VBarry Samuel Higgins · Savoy, IL
Back to AD 90-04-06 R1