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.
N548SPMinter Barry · Rockport, MON5491JChristiansen Aviation LLC · Wilmington, DEN549ASouthern Illinois University · Murphysboro, ILN549BCMitchell Rosemary · Harbour IslandNon-citizen corporation, flight hours not reportedN549BJN549bj LLC · Fayetteville, ARN549EREmbry-Riddle Aeronautical University Inc · Prescott, AZN549MCBulldog Air LLC · Becker, MSN549NDSpartan Education LLC · Tulsa, OKN54EMAvirone Ltd · Monsey, NYN54JASan Carlos Flight Center Inc · San Carlos, CAN54KPScheuers Alan · Murfreesboro, TNN54LULetourneau University · Longview, TXN54ZAWestside Gas Inc · Tucson, AZN550CPCivil Air Patrol · Maxwell Afb, ALN550ERCoco Aircraft Inc · Merritt Island, FLN550LAOscar Tango LLC · Mesa, AZN550NDPhoenix East Aviation LLC · Daytona Beach, FLN5518GChristiansen Aviation LLC · Wilmington, DEN5518WChristiansen Aviation LLC · Wilmington, DEN551ERSunrise Aviation Inc · Ormond Beach, FLN551ESNimno 551es LLC · Pompano Beach, FLN551HPMotorcarlease USA Inc · Miami Beach, FLN551NDCoast Flight Training And Management Inc · San Diego, CAFirst renewal noticeN551SPIllinois State Police · Springfield, ILN5520NChristiansen Aviation LLC · Wilmington, DEN5520SChristiansen Aviation LLC · Wilmington, DEN5520UChristiansen Aviation LLC · Wilmington, DEN5520XUS Aviation Training Solutions Inc · Titusville, FLN55218Christiansen Aviation LLC · Wilmington, DEN5521QEckmann Sheri L · Santa Barbara, CAN5521SChristiansen Aviation LLC · Wilmington, DEN5522A5522a LLC · Bethany, OKN5522SAmeriflyers Of Texas Inc · Addison, TXN5522XChristiansen Aviation LLC · Wilmington, DEN55231Golf November Aero LLC · Sunnyvale, CAN55234Alien Invaders LLC · Medina, WAN5523QDolphin Leasing LLC · Daytona Beach, FLN5523VDolphin Leasing LLC · Daytona Beach, FLN5524CStewart Kyle · Santa Barbara, CAN5525RJwh Dalton Holdings LLC · Brentwood, TNN5526JBravo Leasing LLC · Daytona Beach, FLN55285Aerosim Academy Inc · Sanford, FLN55292Aerosim Academy Inc · Sanford, FLN55294Heavy Metal Air LLC · Farmingdale, NYN55296Heavy Metal Air LLC · Farmingdale, NYN55297Goodhue LLC · Myrtle Beach, SCN5529ZAerosim Academy Inc · Sanford, FLN552MNMtc Air LLC · Blue Ridge, GAN552NDOdegaard Wings Inc · Kindred, NDN552SPEngineers Flying Club Inc · Bethany, OK
Back to AD 2003-24-13