AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N6997RTimmons Tracy · Jacksonville, ILN6997UDoull Leyla · Miami, FLN6997WKeeter Michael P · Proberta, CAN6998BKoch Michael L · Neosho, WIN6998JMt Aircraft Sales And Leasing LLC · Wilmington, DEN6998NPacifica LLC · Grand Junction, CON6998PProven Frederick A · Hammond, NYN6998WTutunik Aleksandr · Lake Hughes, CAN6999Mccown Robert D · Eagle River, AKN69997Mckenney Bret · Billings, MTN6999BGochenour Tim B · Macy, INN6999DN6999d LLC · Fairfax, VAN6999JSun West Aviation Inc · Santa Ynez, CAN6999KHalpin William J · Eden Prairie, MNN6999QBas Part Sales LLC · Greeley, CON6999URuff Daniel D · Yacolt, WAN6999VBredthauer Glen E · Hastings, NEN6999WSilva Javier · Sanger, TXN699AClifford Wiliam J · Williston Park, NYN699AKJkl Flites LLC · Kalispell, MTN699AVAir Ventures Hawaii LLC · Lihue, HIN699BMunn Kenneth D · Zephyr Cove, NVN699CBBig Skylands Aviation LLC · Succasunna, NJN699CPCivil Air Patrol · Maxwell Afb, ALN699DKN699dk LLC · Caledonia, MIN699DMBarber Christopher A · Toney, ALN699DSNimer David K · Malad City, IDN699DWDw Flight LLC · Columbus, OHN699FLEdgewood Acres LLC · Willmar, MNN699HAviat Aircraft Inc · Afton, WYN699JBBaker James W · Goodland, KSN699LCAero Management LLC · Austin, TXN699LGN699 Lg LLC · Mahtomedi, MNN699LHFf22 LLC · Scottsdale, AZN699RBMaoz Eyal Trustee · New York, NYN699RVHughes Adrian P · Everett, WAN699SPMa Aviation LLC · Danville, ILN699WSeabourn Scott R · Newberg, ORN699WPHilke Robert J · Carson City, NVN699ZMichfab Machinery Inc · Grand Rapids, MIN69AAStauber Michael G · Manhattan Beach, CAN69AHCavu Charters LLC · Stuart, FLN69AJKolea Leasing LLC · Honolulu, HIN69APScott Brady · Manakin-Sabot, VAN69AUThoma George E · Old Lyme, CTN69BLykins Matthew · Stevensville, MTN69BCStephen Korney · Norwalk, CAN69BNSky West Aviation Inc Trustee · Albuquerque, NMN69CGCharley Golf LLC · Wilmington, DEN69CNTachoir Steven E · Marienville, PA
Back to AD 81-18-04 R2