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.
N161PSBond Robert E · Knoxville, TNN161RPCrucial LLC · Kalispell, MTN161SAAviation Consultants Inc DBA · San Luis Obispo, CAN161SEOquinn Timothy M · Tehachapi, CAN161SG3bs Aviation LLC · Wilmington, DEN161SWLober Cameron K · Matthews, NCN161TCAkrotown USA LLC · Tualatin, ORN161TFAirmart Inc · Lexington, KYN161WAWashburn Aviation LLC · Murfreesboro, TNN1622PBaker Kenneth C · Brenham, TXN16237Main Line Assets LLC · Wayne, PAN16244Oakland William S · New Port Richey, FLN162505b Aviation LLC · Duncan, OKN16252Robbins Warren N · Chandler, AZN16253Quincy Aircraft LLC · Quincy, ILN16257Chauvet Nicolas · North Kingstown, RIN1625LArtime Jorge Daniel · Miami Beach, FLN16269Kelley John Charles · Hot Springs Ntl, ARN16273Taildraggers LLC · Syracuse, KSN16278Cademartori Joel T · Norris, TNN16279Deyoung Christopher H · Tucson, AZN16292Morcom Aviation Services Inc DBA · Everett, WAN16293Quale Jeffrey L · Craig, COFirst renewal noticeN16299Piper Niner Niner LLC · Evansville, INN162AVPiper Aircraft Inc · Vero Beach, FLN162BCRegistration Pending · Tampa, FLRegistration pendingN162CPCivil Air Patrol · Maxwell Afb, ALN162CSFrielingsdorf Tim Richard · Manvel, TXN162FCSanders Racing Inc · Jasper, ALN162JKAlf Ix LLC · Chicago, ILN162MAHearne Scott N · Powderly, TXN162MEIasco Flight Training Inc · Redding, CAN162PCBoard Of Trustees Of Western Michigan University · Battle Creek, MIN162PMFrench Loren · Gypsum, CON16305Fross James B · Wichita, KSN16311Toxen Robert M · Fort Lauderdale, FLN16313Sanders Christopher Scott · Knoxville, TNN16319Bethers Michael R · New Market, MDN16320Basurto Kathryn A · Sacramento, CAN16321Chamberlain Frederick L · Tavernier, FLN16322Liggett Esaias Martin · Union, KYN16329Greensite Phillip M · Walton, KYN1632HM & B Aero LLC · York, PAN16332Brown Chritopher M · Lake Helen, FLN1633CUS Aviation Training Solutions (Usats) · Titusville, FLN16343Starlight Real Estate Investments Inc · Punta Gorda, FLN16350Dunn Mitchell R · Hayden, ALN16351Degraaff Norman L · Friday Harbor, WAN16359Skinner Colin L · Hartland, VTN1635PRegistered aircraftN-number assigned, not yet registered
Back to AD 2006-10-21