AD 2000-18-53
Registered aircraft · 45,248
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:2000-18-53')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-18-53')
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:2000-18-53') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-18-53') 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.
N103NCState Of North Carolina · Raleigh, NCN103PZRaging Thermal Sky Sports LLC · Brighton, CON103RRLancaster Flyers LLC · Fenwick Island, DEN103SAHolman Steven R · Vero Beach, FLN103SJBarnick Air Holdings LLC · Santa Barbara, CAN103TXWilliams Bradley H Jr · Charleston, SCN103URankin Kenneth · Pinellas Park, FLN103VWVan Wagner Aerial Media LLC · Hollywood, FLN1040JHefferon John W · Locust Grove, GAN1040UAmerican Aviation Inc · Brooksville, FLN1040XRacette Robert J Jr · Vienna, WVN1041HCentury Flight Systems Inc · Mineral Wells, TXN1041QSwaz Aviation LLC · Mesa, AZN1041SN1041s LLC · Key West, FLN1041URegistered aircraftN1042SPiper Cameron · Winchester, VAN1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCN1042XN1042x LLC · Papillion, NEN1043JLanmon Herman Jr · Hamilton, TXN1043QRegistered aircraftN1043SAmerican Aviator LLC · Newark, DEN1043UClinton Arlys L · Fair Oaks, CAN1043XAustin Security Corp · Battleboro, NCN10446Schell Brothers II LLC · Rehoboth Beach, DEN1044JNagasaka Bruce J · Weiser, IDN1044LFitch Mark · Anchorage, AKN1044NMaule Flight Inc · Moultrie, GAN10457Six Ten Ventures LLC · Cedar Hill, TXN1045JFenn Matthew A · Liberal, KSN1045LBernard Robert J · Millbury, MAN1045YRovers Bradley S · Chazy, NYN1046XFarnham Aviation Services LLC · Ames, IAN10470Leary Dan P · Girdwood, AKN1047JFirst Flight Investments LLC · Bartow, FLN1047UStueve'S Certified Organic Dairy · Oakdale, CAN1047YDonato Deleonardis · Paulden, AZN10480Piper 66 LLC · Kirksville, MON1048AUnderdahl Kirby L · Hamilton, MTN1048EPaul John R · Boise, IDN1048LSparrow Thomas E · Hawley, MNN1048TTrotter Thomas J · Bremerton, WAN1048XLogan Colton Dean · Pagosa Springs, CON1049JLoxley Jason C · Virginia, ILN1049PLamal Thomas K · Fairbanks, AKN104ABPeterson Kevin D · Peoria, AZN104ALDinardi Allen J · Jacksonville, ORN104BCHoudek Todd L · Roseburg, ORN104BLSpiva Brett · Knoxville, TNN104BVSea Horse Sportfishing LLC · Clinton, NCN104DFHayton Thomas M · Arcadia, OK
Back to AD 2000-18-53