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.
N5253CMustang Sally Aviation LLC · Camden, SCN5253XMaranatha Insurance Service Inc · Rancho Cucamonga, CAN5254ABuffy Aero LLC · Suwanee, GAN5254QRocky Mountain Flight Consultants LLC · Boulder, CON5254WGlacier Peak Aviation LLC · Carnation, WAN5255RZin Services LLC · Dover, DEN5256SFargo Jet Center LLC · Fargo, NDN5257ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN5258YChristiansen Aviation LLC · Wilmington, DEN525MJCohen Heath P · Lake Havasu City, AZN525NDAerosim Academy Inc · Sanford, FLN52606Cirrus Aviation Inc · Sarasota, FLN5262QReinhart Gregory D · Waunakee, WIN5262UL&W Aircraft Investment LLC · Homestead, FLN5262YLead Turn Aviation LLC · Ogden, UTN52642Valiair Ltd Co Trustee · Casper, WYN5264RHenslee Aviation LLC · Hobbs, NMN52657Honeycutt Holdings Inc · Charlotte, NCN5266GMtf Aviation LLC · Salem, ILN52678Land And Sea Aviation Alaska LLC · Anchorage, AKN5267RCastlegate Corp · Monee, ILFirst renewal noticeN5267YCkb Management LLC · Fayetteville, ARN52694Sullivan Michael E Trustee · Granite Bay, CAN5269NHigh Maintenance Inc · San Luis Obispo, CAN526BLWarren Flying Club Inc · Troy, MIN526EPEpic Aviation Inc · Denison, TXN526ERLong Island Aviators LLC · Seaford, NYN526LKKenzy 2022 LLC · Castle Rock, CON526MEMike Whiskey Echo LLC · Camden, DEN526NDSpartan Education LLC · Tulsa, OKN5270GLewis University · Romeoville, ILN52712Macmillan Elizabeth A · Franklin, MAN52715Echo Sierra 54 LLC · Hagerstown, MDN5271BTexas Department Of Public Safety · Austin, TXN5271FUnverfehrt David C · Ocala, FLN5272NMaddie LLC · Hinton, WVN5273FPsc Leasing LLC · Nokesville, VAN5273KColumbia Fire & Safety LLC · Wilmington, DEN5273UKatola LLC · Anaheim, CAN5274VH & R Aviation LLC · West Linn, ORN52753Omark Aviation LLC · Naples, FLN52757Brady Aviation Ltd Co · Friendswood, TXN5275CRamaswamy Ashok · Clearwater Beach, FLN5275S75s Leasing LLC · Greenwood Village, CON5275WMustang Sally Aviation LLC · Camden, SCN52766Krobkrua Tio LLC · Snowflake, AZN5276PBellers Aviation Inc · Fremont, CAN5276YPadlock Ranch Co · Ranchester, WYN5277LM2c2 Air LLC · Carlisle, PAN52794Hawk Flyer 794 LLC · San Bruno, CA
Back to AD 2003-24-13