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.
N69981Nickel Peggy L · Ankeny, IAN69985Gibbs Robert I · Ravenswood, WVN69989Trissell Flying Service Inc · Clarksville, TXN6998BKoch 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, AKN69991Jko Aviation LLC · Helena, MTN69993Jones Jody D · Stilwell, OKN69996War Eagles Air Museum · Santa Teresa, NMN69997Mckenney 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, NYN699BMunn Kenneth D · Zephyr Cove, NVN699DKN699dk 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, AZN699RVHughes Adrian P · Everett, WAN699WPHilke Robert J · Carson City, NVN699ZMichfab Machinery Inc · Grand Rapids, MIN69AAStauber Michael G · Manhattan Beach, CAN69APScott 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, PAN69CZVermeylen John B · Altamont, TNN69DASwanson Brian W · Mount Morris, NYN69DLIndy Air Sales LLC · Anderson, INN69DSSale Reported · Tomball, TXSale reportedN69DYJohnson Christopher · Tulsa, OKN69ETSale Reported · Nampa, IDSale reported, pending cancellation
Back to AD 90-04-06 R1