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.
N346CPPinnacle Aviation Services Inc · Encinitas, CAN346CSBooth Kristen E · Columbia, SCN346DProfessional Training Aircraft LLC · Wilmington, DEN346DWValiair Lc Trustee · Casper, WYN346ENorth Coast Aeronautical LLC · Cleveland, OHN346FSRichard C Reed · Snyder, TXN346GGJoey Os LLC · Darlington, PAN346JMOveross James A · Independence, ORN346JWChastain Jane S Trustee · Greeley, CON346LERegistration Pending · Panama City, FLRegistration pendingN346MCSkyway Aviation LLC · Purvis, MSN346MKNorth Star Aviation · Mankato, MNN346PTLott Michael Clinton · Carriere, MSN346RAThompson Christopher C · Hillsboro, WIN346RBHinson Taylor C · Prairie Village, KSN346RMHansen Alexander G · Glendale, CAN346RNSchroll Charles E · Tucson, AZN346RSSutterfield Stefany · Austin, TXN346RVDill John · Huntley, ILN346S200 Knot LLC · Amarillo, TXN346SPFlightline Air Service LLC · Pineville, LAN346VHAllen Joseph Andrew · Trumbauersville, PAN346ZRussell David B · Marion, ARN34701Spirit Of St Louis Flying Club Inc · Chesterfield, MON34707Swanborg Valerie · Wausau, WIN34708Ebner Raymond J III · Middleburg Heights, OHN34709Neal Randall C · Lincoln City, ORN3470NDavis Brandon K · Kansas City, MON3470RCook Chayil LLC · Granger, INN3470TPorte Elvis · Miami, FLFirst renewal noticeN3470UThird Loop Partners · Paso Robles, CAN34710Warden Leonard D · Anacortes, WAN34717Schwenker Richard L · Maquoketa, IAN3471FDel Norte Flying LLC · Del Norte, CON3471GPage Garrett A · Rhodes, MIN3471MParis Air Inc · Vero Beach, FLN3471RKilpatrick Kerry · Somerset, NJN3471SClint Woodword Construction LLC · Prineville, ORN3471WKoranda Amy B · Salem, SCN3471ZWyly Billy W · Okaton, SDN34720Bulls Eye Trading LLC · Bethany, MON34723Pulliam Donald Edward · Wake Forest, NCN34727Valley Fliers Flying Club · Auburn, WAN34728Deleon Joseph M · Saint Petersburg, FLN34729Registered aircraftN3472FMiller Robert F · Locust Grove, GAN3472GLosko Patrick J · Tustin, CAN3472RKomar Michael J · Danville, PAN3472XWei Jeremy · Holmdel, NJN34731Edenhoffer Peter J · Paris, TX
Back to AD 2007-04-19 R1