AD 2000-23-21
Registered aircraft · 47,142
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-23-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:2000-23-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:2000-23-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:2000-23-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.
N114WREstes Aviation LLC · Vicksburg, MSN1150UHaskins Kerry H · Tampa, FLN1151UCoconut Telegraph LLC · Missoula, MTN1151XSummers Jayson V · Poway, CAN1152KVan Hook James W · Sylvania, OHN1152LMcdonald Glenn · Uvalde, TXN1152NDowd Tedd J · Goodyear, AZN1152QHilterbrand Wayne D Jr · Keizer, ORN1152VGolden Eagle Consulting LLC · Williston, NDN11532Cirrus Design Corp · Duluth, MNN1154ZRegistered aircraftN1156Ind Aerospace LLC · Lumber Bridge, NCN1156GWilliams Michael E · Horseshoe Bay, TXFirst renewal noticeN1156KN1156k 231 LLC · Dearborn Heights, MIN1156MJays Aircraft Maintenance Inc · Costa Mesa, CAN1156TAero 1 LLC · Kalispell, MTN1157GPennington P · The Colony, TXN1157JAvinate LLC · Orlando, FLN1157KBistline Luke W · Tooele, UTN1157LFurf Air Inc · Venice, FLN1157MWhf Aviation LLC · Jamestown, OHN1157PPourcho William S · Bloomfield Hills, MIFirst renewal noticeN1157QRrc Inc · Madison, MSN1157TSalloom Mary M · Gaithersburg, MDN1157VJohnson Lisa Nicole · Klamath Falls, ORN1157WAdams Chad D · Dayton, ORN1158CZbylut Luke · Amherst, MAN1158NAviation Endeavor Society LLC · Leander, TXN1159DZollars Thomas B · Dallas, TXN1159QPeak Aviation LLC · Salida, CON1159TNxtday Aire LLC · Dover, DEN1159VShular Rodger D · Antelope, CAN115AWMillican Marc J · Anchorage, AKN115BHBighorn Airways Inc · Sheridan, WYN115CGrand Valley Air LLC · Wyoming, MIN115CA8k Entertainment Inc · Wells, MEN115CCPlane Guys LLC · Saint Onge, SDN115CDHigh Flying Investments LLC · Texarkana, ARN115CKSchmick Kenneth R · Fond Du Lac, WIN115CNHevven LLC · Dunedin, FLN115CWWhitlock Gary D · Melbourne, FLN115DJAv8 Ohio LLC · Lancaster, OHN115EATso Aviation LLC · Conway, ARN115EL182 Flight Corp · Bronx, NYN115ESSpeedynrw LLC · Brownsville, TXN115FPBas Part Sales LLC · Greeley, CON115JBSnoopy & Baron LLC · Driftwood, TXN115KFMiles Matthew W · Havre, MTN115KVKva Electric Inc · Arlington, WAN115MLRyo LLC · Cedar Park, TX
Back to AD 2000-23-21