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.
N6191APearson Aero Solutions LLC · Dallas, GAN6193CAirspeed Mammography Certifications LLC · Olympia, WAN6193DDe Anza Building And Maintenance Inc · Los Altos, CAN6193MFreiesleben Thomas K · Brookfield, WIN6193RAircraft Guaranty Corp Trustee · Oklahoma City, OKN61942Middle Village Enterprises LLC · Maspeth, NYN61944Kaitooth Flight Club LLC · Kalispell, MTN61948Ac Ag Management LLC · Johnson, KSN6194VChristiansen Aviation LLC · Wilmington, DEN61958Hff Leasing LLC · San Diego, CAN61959Scandinavian Aviation Academy Inc · El Cajon, CAN6195CRoberts Aviation LLC · Acworth, GAN6195SRehg Robert F · Parker, CON6196GFirst Air Service LLC · Show Low, AZN6196PChristiansen Aviation LLC · Wilmington, DEN6196XPrecheck General LLC · Alamogordo, NMN6197FRed Baron Aeroplanes LLC · Eaton, CON6197ZClermont Management Services Inc · Marietta, GAN61984Tru Flight Materials LLC · Wilmington, DEN61987Twilight Flying LLC · Lafayette, LAN6198NChristiansen Aviation LLC · Wilmington, DEN6199SKilo Tango Aviation LLC · Watford City, NDN6199VCasperson Jeffrey Lynn · Clintonville, WIN619CBBeers Aviation LLC · Cedar, MIN619CTCoast Flight Training And Management Inc · San Diego, CAN619EREmbry-Riddle Aeronautical University · Prescott, AZN619SPJet Air Inc · Iowa City, IAN619THAce Aviators LLC · Logan, UTN619WAMckee John D · Dallas, TXN619WCHansford Mark T · Blue Ridge, GAN61BGGray Skyhawk LLC · Fredericksburg, TXN61BXAviation Trust Co Trustee · Oklahoma City, OKN61CEBarr Air Patrol LLC · Mesquite, TXN61HSCebuhar Phillip Joseph · Inola, OKN61RRAap Holdings LLC · Montana City, MTN61USLakes Aviation LLC · Lakewood, ILN61WTMonmouth Area Flying Club Inc · Lakewood, NJN6200DLundgren Mark C · Philipsburg, MTN6201APhenix Transportation LLC · Sheridan, WYN6201UFlashley Flies LLC · Menlo Park, CAN62030Aht Aviation LLC · Doral, FLN62048Gv Air Inc · Medford, ORN6206Maunder Mark · Eastsound, WAN6206XVan Bortel Aircraft Inc · Arlington, TXN6208CMustang Sally Aviation LLC · Camden, SCN620EREmbry-Riddle Aeronautical University Inc · Prescott, AZN620HPDepartment Of Public Safety · Norman, OKN620JASilverhawk Aviation Academy LLC · Caldwell, IDN620SPGulf Coast Aviation LLC · New Orleans, LAN620WTStilley David · Flagstaff, AZ
Back to AD 2003-24-13