AD 2003-24-13
Registered aircraft · 7,870
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-24-13')
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-24-13')
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-24-13') 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-24-13') 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.
N187DHPsl Surveys · Bristow, VAN187HSGlidewell Aviation Inc · Parkland, FLN1882SWings Over L A Aviation LLC · West Hills, CAN1884MMontgomery Aviation LLC · Zionsville, INN188AGRvest Management LLC · Boulder City, NVN188AHAlf Ix LLC · Chicago, ILN188CACivil Air Patrol · Maxwell Afb, ALN188CPCivil Air Patrol · Maxwell Afb, ALN188CSJaae Inc · North Miami Beach, FLN188MESenior Mi LLC · Batavia, ILN188SSNby Productions · Bristow, VAN188VEFly Skyhawk LLC · Peoria, AZN1896BSmart John B III · Southlake, TXN189CBOtv Leasing · Bristow, VAN189CPCivil Air Patrol · Maxwell Afb, ALN189JCTulare County Sheriff · Visalia, CAN189JMJsc Rentals LLC · Missoula, MTN189JPMontana Skies LLC · Kalispell, MTN18ACHillsboro Aero Academy LLC · Hillsboro, ORN18HPState Of Ohio · Columbus, OHN18LWDirty Side Down Aviation LLC · Georgetown, TXN18PMNoel Michael Patrick · Poplar Grove, ILN190LPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeN190MEMenagerie Enterprises Inc DBA · Denison, TXN190PDCommonwealth Of Puerto Rico Policia Of Puerto Rico · San Juan, PRN1916JCareer Track 2 LLC · Wilmington, DEN19194Smokey Bear Air LLC · Cascade Locks, ORN1919UD&S Aviation LLC · Spring, TXN191CACsa Aircraft Leasing LLC · Salt Lake City, UTN191FAHarvey Taz E · Danville, CAN191MBFvx Research · Bristow, VAN1926REmbry Riddle Aeronautical University Inc · Daytona Beach, FLN19277Roundtree Sod Service Inc · Jacksonville, FLN192JPBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN192MCWarrington Flying Club Inc · Doylestown, PAN192MEKindrick Jan W · Mt Vernon, TXN192TGSaz Dynamics LLC · Daly City, CAN192WBPsl Surveys · Bristow, VAN192YSanders Leonard S III · Electric City, WAN1931HMountain Air Aviation LLC · Fruit Heights, UTN1934GAero-Tech Services Inc · Lititz, PAN19369Aci Aviation LLC · Costa Mesa, CAN1939SFallon Timothy · Center Barnstead, NHN193GMRkt Productions · Bristow, VAN193MEHorizon Flight Center LLC · Chesapeake, VAN193PNc Wildlife Resources Commission Enforcement Div · Raleigh, NCN193THWingsleasing LLC · Wichita, KSN193VBAli Suleiman Md Inc · Beckley, WVN1941BSan LLC · Knoxville, TNN1947LCal Aggie Flying Farmers · Davis, CA
Back to AD 2003-24-13