AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N3144YSierra Bravo Zulu LLC · Middletown, DEN3144ZWasilowski Richard P · Arlington, WAN31453Kuhlig Clemens C · Hobe Sound, FLN31456Flying Time LLC · Jenks, OKN3145MWright Jeffrey Crandel · Opelika, ALN3145QN3145q LLC · Cave Creek, AZN3145RSchnell Tyler C · Spearman, TXN3145SCorriher Ronald R · Mount Ulla, NCN3145WIfly Aviation LLC · Conway, ARN3145YSiskiyou Aviation LLC · San Jose, CAN31465Stewarts Aircraft Service Inc · Waynesville, OHN3146FMeyer Jackson · Soldotna, AKN3146LGarnett Robert A · Drewsey, ORN3146QJpw LLC · Red Lodge, MTN3146RBednarik Edward L · Morgantown, PAN3146SBell Stephen Francis Trustee · Ponte Vedra, FLN3146UAscend Aviation LLC · Post Falls, IDN3146WWalker Ernest F · Bala Cynwyd, PAN31471Hangar 21 Aviation Inc · Lake Havasu City, AZN31474Nemeroff Jason R · Scappoose, ORN31475Southern Aircraft Consultancy Inc Trustee · Casper, WYN3147CSchlutz Ivan F · Longmont, CON3147LBrowning Charles H III · Woodbine, MDN3147QBernbeck Alan R · Benton, KSN3147TClinton Grant A · Portage Des Sioux, MON3147WTadesco Rothchild LLC · Wilmington, DEN3147ZNeudorf Robert H · Alamogordo, NMN31482First Flight Aero LLC · Reno, NVN31485Unusual Attitudes LLC · Bates City, MON3148CFreund Timothy P · Mesa, AZN3148PSky Hi Aviation LLC · Wilmington, DEN3148RMyl High Flying Club LLC · Mccall, IDN3148SHauser Family Flying LLC · Mount Pleasant, PAN3148TMiller John W · Bluffton, INN3148YHernandez Alfonso C · Garland, TXN31494Locker Aircraft Inc · Muleshoe, TXN31497N400sr LLC · Astoria, NYN3149LChopper 4 LLC · Dover, DEN3149QClear Air LLC · Ashford, CTN3149TShugart Fredrick William · Canfield, OHN314AKTremble Toby K · Wasilla, AKN314AVN1412v LLC · Manassas, VAN314BAComer Jacob · Troy, MON314DBButler David Trustee · Palos Park, ILN314DGLaminar Holdings LLC · Sheridan, WYN314DSFlyers Unlimited LLC · Tucson, AZN314EPHeadings Andrew R · Blue River, WIN314FRHawkeye Helicopter LLC · Lyndon, KSN314GTYellow Jacket Flying Club Inc · Atlanta, GAN314HBMarc Inc · Bolton, MS
Back to AD 2007-04-19 R1