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.
N974THRidgeline Assets LLC · Wilmington, DEN9754FFirst Eclipse Ltd · Richmond, VAN975CPCivil Air Patrol · Maxwell Afb, ALN975CSTextron Aviation Employees Flying Club Inc · Wichita, KSN975TAMitchell David G · Cadiz, OHN975THAnson Air LLC · Sugar Land, TXN9761XMichael Edwin Madison Aircraft LLC · Chattanooga, TNN9764FFixed Wing Holding Co Inc · Pembroke Pines, FLN9767FMid Island Air Service Inc · Ronkonkoma, NYN976CPCivil Air Patrol · Maxwell Afb, ALN9774FTailwind Aviation Solutions LLC · Perry, GAN977CSSouthwell Brent Alan · Houston, TXN977THHeavy Metal Air LLC · Farmingdale, NYN978APAviation Leasing Company LLC · Ooltewah, TNN978CPCivil Air Patrol Inc · Maxwell Afb, ALN978FASky Training LLC · West Milford, NJN978KWOrtega Aviation Services LLC · Wichita, KSN978RABdk Pegasus LLC · Bastrop, TXN978SAMarine Tech One LLC · Dover, DEN978SPLlp Leasing Group LLC · Lewes, DEN9791FRedstone Arsenal Flying Activity · Redstone Arsenal, ALN9799Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN979BCMacinnis Charles E · Harbor Springs, MIN979BVTextron Aviation Inc · Wichita, KSN979CPCivil Air Patrol Inc · Maxwell Fb, ALN979EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN979SFMaus Stephen N · Bozeman, MTN979WDDolphin Leasing LLC · Daytona Beach, FLN97ATRainier Flight Service LLC · Renton, WAN97FFPeregrine Howard Fund V Owner LLC · New Orleans, LAN97HYFulghum Michael Eugene · Humble, TXN97LFSpengler Raymond Francis Jr · Longview, TXN97NJT & W Delaware Leasing LLC · Wilmington, DEN97PDBoeing Employees Flying Association Inc · Renton, WAN97RWWiplinger Robert D · Inver Grove Hts, MNN97VACamps Bay Aviation LLC · Waukegan, ILN980CPCivil Air Patrol Inc · Maxwell Afb, ALN980SPFisher Stables And Arena Inc · Gladewater, TXN981BCSilverhawk Aviation Academy LLC · Caldwell, IDN981BTPea-Wayman Flight LLC · Daytona Beach, FLN981CPCivil Air Patrol Inc · Maxwell Afb, ALN981DRCorder David · Corona De Tucson, AZN981GTPatriot Aviation Inc · Greenville, DEN981MRJlove LLC · Vienna, VAN981SFAtp Aircraft 1 LLC · Wilmington, DEN981SPLlp Leasing Group LLC · Lewes, DEN981TCPeterson Timothy J · Watertown, SDN981TWKent Mark · Holden, MAN981WSNayrmarc LLC · Linden, MIN981WUEastern Kentucky University · Richmond, KY
Back to AD 2003-24-13