AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N731MQClassic Management Corp · Marion, INN731NCSmith Bryan · Wenatchee, WAN731NRWife Approved LLC · Torrance, CAN731NUNgu Services LLC · Sheridan, WYN731NXCarey Richard · Dallas, TXN731NZWoodgrain Millwork Transportation LLC · Fruitland, IDN731PDInvisible Angels · Washington, DCN731PJBreckenridge Interests Ltd · Corpus Christi, TXN731QGMowbray Jerry H · Reno, NVN731QHK17 Corp · Alamosa, CON731QNOkeeffe William Trustee · San Francisco, CAN731QRAir Rosa LLC · Tupelo, MSN731RRAviation Inventions LLC · Windsor, CON731RWAdvanced Products Sales LLC · Tempe, AZN731SCMoore Scott A · Longview, TXN731TPHangar 28 LLC · Littleton, CON731XXGrimm John H II · Driftwood, TXN731ZBVanderwaal Shane J · Junction City, WIN731ZFTuggle James L Jr · Scottsdale, AZN7320GDelaware Aircraft Trust LLC Trustee · New Castle, DEN7320UYr-Aircraft Leasing LLC · Bethel, AKN73217Ryan Air Inc · Anchorage, AKN73266Macair Aviation LLC · Xenia, OHN7329NRegent Trust Corp Trustee · Wichita, KSN732ADDavis Billy E · Castlewood, SDN732AQGold Star Air · Portland, MEN732AVRomberg Wayne Dennis · Forked River, NJN732AXAnimal Hospital Of Fayetteville Pa · Fayetteville, NCN732BASparks Steve · Hamilton, OHN732BBBishop Thomas W · Decatur, TXN732BHSeven Eagles Aviation Lc · Gainesville, FLN732BKJones Mark A · Johnson City, TXN732BYMartin James Dwight · Lancaster, PAN732CBAire Flight Systems Inc · Midwest City, OKN732CHRegistration Pending · Athens, TNRegistration pendingN732CRGlobal Energy Werks LLC · Ely, MNN732CXEvans Terry W · Corning, IAN732DKMckay Donald E · White City, ORN732DLN732dl LLC · Driftwood, TXN732DMFlying Knights LLC · Farmington, NMN732DQAcme Do It Yourself Tornado Kits LLC · Draper, UTN732DWKowalczyk Ryan · Boise, IDN732DZBbak Mik LLC · Ontario, ORN732ECPompa Oliver · Tucson, AZN732EEK6 Flying LLC · Murtaugh, IDN732ELAndiamo Aviation LLC · Georgetown, TXN732EPPorebski L P Jr · Odessa, FLN732ETCaudill Jimmy L · Grove, OKN732EWFiller Leslie Trustee · Emerald Hills, CAN732EXBorszich Claude C Jr · Phoenix, AZ
Back to AD 2002-07-01