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.
N94823Black Hills Information Security Inc · Bozeman, MTN94825Vaughan Aviation LLC · Leesburg, VAN9482ZChristiansen Aviation LLC · Wilmington, DEN9485ZAtp Aircraft 1 LLC · Wilmington, DEN94862Lone Oak Aviation LLC · Kemah, TXN948CACivil Air Patrol · Maxwell Afb, ALN948CBSouth Plains Implement Ltd · Seminole, TXN948CPCivil Air Patrol · Maxwell Afb, ALN94901Liberty University · Lynchburg, VAN9491DZak Hanne · Bellevue, WAN9491URoumillat Randall P · Dallas, TXN9495FGotair LLC · Spokane, WAN94969Tailwinds Aviation LLC · Madison, MSN94992Mac Air Corp · Benton, KSN9499ZDark Sky Enterprises LLC · Flagstaff, AZN949CPCivil Air Patrol · Maxwell Afb, ALN949RLNational Aircraft Leasing Corp · Greenville, DEN949SPN949sp LLC · California, MDN94CSAviation Trust Company LLC Trustee · Oklahoma City, OKN94GWJ & J 327 LLC · Clare, MIN94JABeaver Aviation South Inc · Fort Myers, FLN94MPMissouri State Highway Patrol · Jefferson City, MON9501FPacific States Aviation Inc · Concord, CAN9501WAwwad Mamdouh A · Walnut Creek, CAN9503QGulf Coast Helicopters Inc · Pearland, TXN9503YRoss Carl D · Arbuckle, CAN9504LTaylor William C · Portsmouth, NHN9506WAttitude Aviation Inc · Livermore, CAN9508WUniversity Of Alaska Anchorage · Anchorage, AKN950CPCivil Air Patrol · Maxwell Afb, ALN950HPKansas Highway Patrol · Topeka, KSN950LPAmeriflyers Of Texas Inc · Addison, TXN9511DEglin Aero Club · Eglin Afb, FLN9511GBurdette Ernest L · Pass Christian, MSN95129Texas State Technical College · Waco, TXN9512FGeorge'S Aviation Services Inc · Honolulu, HIN9512LKreykes K Douglas · Greeley, CON9515QVictory Aviation Club Inc · Hamilton, OHN9515SKingsky Flight Academy LLC · Lakeland, FLN9516JEastern Kentucky University · Richmond, KYN9516WRingco Aviation LLC · Oklahoma City, OKN9518DJaugust Vladimir · Somerville, MAN951JAAerochatt LLC · Cleveland, TNN951MCSky Mates Inc · Wilmington, DEN951SCJuliet Charlie Aviation LLC · Scottsdale, AZN951SPN591sp LLC A Series Of Aero Lease LLC · San Antonio, TXN951TAKb Land And Cattle Company LLC · Hood River, ORN9520DHodge Flight Services LLC · Pittsburg, CAN9520WAmeriflyers Of Texas Inc · Addison, TXN9520ZK2 Aviation LLC · Greenwood Village, CO
Back to AD 2003-24-13