AD 2003-26-06
Registered aircraft · 1,564
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:2003-26-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-26-06')
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:2003-26-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-26-06') 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.
N180MFPapa Sierra Holdings LLC · Dover, DEN1811FMaster Link Corp · Barceloneta, PRN183EHBristow LLC · Lake Charles, LAN183TBBluesky Tb Corp Trustee · Wilmington, DEN183WPLj Horizon Ventures LLC · Fort Worth, TXN184SDCounty Of Orange - Air Support · Costa Mesa, CAN1866SAviation Addiction LLC · Fishers, INN1871SGreen Evan R · Calabasas, CAN1887SCavort LLC · New York City, NYN1888EChoe Young Kyu · Manhasset, NYN188CDN188cd LLC · Tulsa, OKN188GTI&F LLC · Overland Park, KSN188SJDaxen Logistic LLC · Chino, CAN1893SSylvester Donald W · Santa Maria, CAN1894SCravey Equipment Leasing LLC · Kerrville, TXN189GTKenai Aviation LLC · Akron, OHN189TBPacca Club Inc · Attleboro, MAN18SRW4 Air LLC · Willis, TXN1903SGriffin Products Inc · Wills Point, TXN1906SMiskovic Dejan · San Jose, CAN1909SDennerline Rhett R · Northfield, ILN190AVNghiem Daniel · Westminster, CAN190GTRincon Gabriel · Baton Rouge, LAN193BHBlack Mountain Aviation LLC · Boulder City, NVN1967HTbm 700 LLC · Denair, CAN197BHNevada Helicopter Leasing LLC · Greenwood Village, CON197TBHardman Andrew D · Prosper, TXN198SAAbel Air LLC · Dorchester, MAN19DLDmc Aviation LLC · Jacksonville, FLN19GSDel Rey Dock Company LLC · Key Largo, FLN1ETCalifornia Aerospace LLC · San Francisco, CAN1FDSiek Aviation Inc Trustee · Wilmington, DEN1J1596 Inc Trustee · Wilmington, DEN1SDPinellas County Sheriffs Office · Clearwater, FLN1TJCowboy Air LLC · Kingfisher, OKN1VCAlmeida Victor · Telluride, CON200STk Aviation LLC · Willow Street, PAN203CHCoastal Helicopters Inc · Juneau, AKN204CHCoastal Helicopters · Juneau, AKN204MEArgo Aviation Inc Trustee · Wilmington, DEN204YUFly Invest Inc Trustee · Wilmington, DEN20AGInternational Air Services Inc Trustee · Carson City, NVN20AJTwigg Brett · Lincoln, ALN20CQA-1 Heavy Equipments Corporation · Pembroke Pines, FLN20DUHardt Alexander · Tempe, AZN20DXBig Sur USA LLC · Boca Raton, FLN20DYBpw Aviation LLC · Huntsville, ALN20DZWeathers Air LLC · Longwood, FLN20ELJrhav LLC · Chassell, MIN20ETClear Skies Avionics Inc · Clearwater, FL
Back to AD 2003-26-06