AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N1963TCondor Aero Club Inc · Zelienople, PAN1963YLane Cary · Sapello, NMN1964XSchachle Robert Godfrey Jr · Wasilla, AKN1964YPerry Shawn M · Springfield, OHN1965HDeltahawk Engines Inc · Racine, WIN1965YSvoboda Patrick J · Bucyrus, KSN1966LTiger N1966l Corp · New York, NYN1966YWeyhrich Dorothy · Windsor, CON1967FLeander Henry Anske IV · San Antonio, TXN1968TGilbert Zachary A · Jekyll Island, GAN1969FRandel Benjamin Steven · Zionsville, INN1969HTrn Aviation LLC · Mcallen, TXN1969SUpton John W · Evans, WVN1969TN1969 Tango LLC · Green Cove Springs, FLN1969YBiggs Clifford G · Washington, UTN196AMP&W Investments Inc · Wilmington, DEN196DStott David L · Wasilla, AKN196DBBe Right Back Aviation LLC · Boca Raton, FLN196HPSouthtrust Adventures LLC · Pensacola, FLN196JBEltgroth Peter G · Livermore, CAN196JGNine Six Livestock Co · Sterling City, TXN196JRSky West Aviation Inc Trustee · Albuquerque, NMN196MEPacific Lease · Elk Grove, CAN196MTSheboygan Flying Club LLC · Sheboygan, WIN196PFCloudbase Imaging LLC · Erie, CON196PWC I Mckown & Son Inc · Newton, WVN196SA3d Capture LLC · Beaumont, TXN196SQBay Land Aviation Inc · Salisbury, MDN19700Johnson Dean W · Watertown, SDN1970LLark Aviation LLC · Cottrellville, MIN1970PWootton Donald W · Houston, TXN1971YMaurer Andrew · Pepper Pike, OHN1972BPerformance Aircraft Sales Inc · Lincoln, NEN1972KBachtac Aviation LLC · Clarksville, TXN1972PKitcen Thomas M · Indiana, PAN1972WCaruso Timothy Ernest · Gainesville, VAN1973GBarrette Michael Patrick · Saginaw, MIN1973VMurphy Peter · Streamwood, ILN19748Scaringe William A Jr · Culver City, CAN19758Walsh Robert F · Tucson, AZN1975LClarke Ted · La Luz, NMN19762Boyertown Flying Club Inc · Devon, PAN19763N19762 LLC · Tigard, ORN1976BEmerald City Aircraft Leasing Inc · Port Orchard, WAN1976LLuke Ivan T · Hope Valley, RIN1976TSickels Charles Joseph · San Diego, CAN1977DGraynor Jeremy · Los Angeles, CAN1977JPicornell Francisco J · Malabar, FLN1977TTugwell Robert B · Gallatin, TNN1977YTrychon Stephen A · Sterling, MA
Back to AD 2006-10-21