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.
N22761Kop Aviation LLC · El Paso, TXN2277TEngisys Traffic LLC · North Potomac, MDN2278YWplanec LLC · Gig Harbor, WAN227BHPhoenix East Aviation LLC · Daytona Beach, FLN227BSLec Aviation LLC · Winter Garden, FLN227CPCivil Air Patrol · Maxwell Afb, ALN227RJFrost Cavin B · Odessa, TXN227TFTop Flight Aviation Inc · Corona, CAN227TWChristiansen Aviation LLC · Wilmington, DEN227WCHuerta Holdings Inc · Woodland Hills, CAN227WFTrayler James · Waco, TXN22801Career Pilot Training LLC · Wilmington, DEN22803Career Pilot Training LLC · Wilmington, DEN22806Career Pilot Training LLC · Wilmington, DEN22807Career Pilot Training LLC · Wilmington, DEN22808Career Pilot Training LLC · Wilmington, DEN22809Career Pilot Training LLC · Wilmington, DEN22810Career Pilot Training LLC · Wilmington, DEN22813Career Pilot Training LLC · Wilmington, DEN22816Career Pilot Training LLC · Wilmington, DEN22818Career Pilot Training LLC · Wilmington, DEN228AZCiaglia Caesar Earle · Mokena, ILN228HSSweeney David H · Houston, TXN228JPMazel Wings LLC · Camden, DEN228TWNorth Delta Aviation LLC · Blytheville, ARN22904Phoenix East Aviation LLC · Daytona Beach, FLN2290AOrtega Aviation Services LLC · Wichita, KSN2291CForty Four Fifteen LLC · Reno, NVN2291SRegistered aircraftN2292WA & L Enterprises LLC · Maiden Rock, WIN22952Winging It LLC · Lindon, UTN2296NMacsdea LLC · Van Nuys, CAN2297VTicknor Robert James · Adel, IAN2298WGoli Aviation LLC · Raleigh, NCN229CACivil Air Patrol · Maxwell Afb, ALN229CPCivil Air Patrol · Maxwell Afb, ALN229ESilver Creek Aviation Services · Fort Worth, TXN229LPDuke Air LLC · Romeo, MIN229METom Wood Aviation Inc · Fishers, INN229WCJeffery & Weiss Holdings LLC · Long Beach, CAN22CHSupergo LLC · Menlo Park, CAN22CSClear Skies Aviation Enterprise LLC · Dover, DEN22CUGbh Aviation · Santa Monica, CAN22HYTlc2 LLC · Missoula, MTN22SJWright James M · San Diego, CAN2301QFarm West LLC · Missoula, MTN2302YMustang Sally Aviation LLC · Camden, SCN230BKErickson Bernard Rudolph · Saint Cloud, MNN230CPCivil Air Patrol · Maxwell Afb, ALN230EPEpic Aviation Inc · New Smyrna Beach, FL
Back to AD 2003-24-13