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.
N1800PRegistered aircraftN1800RSugrue Aviation Inc · Silver City, SDN18010Sale Reported · LavalaSale reportedN1801EValdes George · Pembroke Pines, FLN18026Registered aircraftN18038Overton Asset Group LLC · St Marys, IAN1804HBl&B LLC · Knoxville, TNN1804QCliff Robinson Real Estate Corp · Madison, INN1805HIronworks Asset Resources LLC · Chesapeake, VAN1806HKessler Derek · Lexington, OKN1806MCareer Track 2 LLC · Wilmington, DEN1806RFly By Night Aviation Inc · Pleasantville, NYN1807RVeldman Richard D · Laporte, INN18087Small Mountain Flyers LLC · West Monroe, LAN1808JNeissel Mark D · Gig Harbor, WAN180ACDupont Cody C · Allison, TXN180AMKnight Larry L · Fayetteville, GAN180ASWard Jeffrey K · Kennesaw, GAN180BVGarcia Karin M · Richland, WAN180CAGrosslight Greg · Afton, WYN180CCMorrison Gerald L · Kansas City, MON180CGBailey Bendrix · Rochester, MAN180CPCivil Air Patrol · Maxwell Afb, ALN180CQKehoe William R · Port Clinton, OHN180CVN Registration Service LLC Trustee · Sanford, NCN180DDDaniels David R · El Paso, TXN180DPHarvey Marjory J Trustee · King George, VAN180EGroom Lucas W · Williamsburg, VAN180EBWachholz James A · Two Rivers, WIN180ENNealey Eric D · Barrington, ILN180EXPendergrass Thomas · San Marcos, TXN180FOhl-Trlica Chandler · Vienna, VAN180FGRoberts Todd L · Friday Harbor, WAN180GAda Forestry Division · Malvern, ARN180GGGoral William W · Redlands, CAN180HJSummit Peak Holdings LLC · Missoula, MTN180HUScarberry Dennis Lee · Goddard, KSN180JNNealey James L · Buffalo, WYN180KYValiair Lc Trustee · Casper, WYN180LARonsman Harry M · Talkeetna, AKN180LKBoston Commercial Corp Trustee · Wilmington, DEN180LSSimonson Larry · Dalton, MNN180MAMuston Scott A · Ypsilanti, MIN180MLBearden Harold H · Haleyville, ALN180MXN180mx LLC · Sherwood, ORN180NHWells Michael G · Salado, TXN180PHd Utilities And Grading LLC · La Vista, NEN180SDMoore Philip R · Thompsons Station, TNN180SPMachado David V · Kenai, AKN180SUOhio State University · Columbus, OH
Back to AD 2006-10-21