AD 80-25-07 R1
Registered aircraft · 25,370
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N3505HSingleton Todd D · Lexington, TNN3505XSiegel Craig A · Tucson, AZN35060Anderson Brian G · Thief River Falls, MNN35061Delucia Dennis DBA · Franklin, PAN35065Newman Richard T · Seattle, WAN35068Monroe Robert S · Oceanside, CAN35069Duffek John C · Hillsborough, NJN3506XBevers David A · Colfax, CAN35074Nanny Stephen D · Eagar, AZN35076Bishop William M · Rougemont, NCN3507FAerial Oklahoma LLC · Oklahoma City, OKN3507HCreel Adam · Hoover, ALN35083J3 Enterprises LLC · Colquitt, GAN35086Robison David P · Spencer, IAN35088Apple Jeffrey G · Sheridan, INN35089Caldwell Enterprise Inc · Grand Prairie, ILN3508XPietrs Robert A · Madison, ALN35091Kinard Taylor Layne · Collierville, TNN35093Staples Clint B · Nemo, TXN35099Edwards Rex W · Monroe, NCN3509HPer Ardua Ad Astra Inc · San Luis Obispo, CAN350GZValiair Lc Trustee · Casper, WYN350LCDaly Arthur P · El Paso, TXN350SQGriffith Aviation Inc · Griffith, INN350XWeishaar Wallace O · Livingston, TXN35100Harper Gary E · Walton, WVN35101Diamond K Gypsum Inc · Richfield, UTN35102Allen Russell W Trustee · Ada, OKN35107Osmers Michael · Luray, VAN3510HNix Terry W · Golden, MSN3510NVenture Eleven Aero LLC · Huntsville, ALN3510XCuccia Joseph A · Hazen, NDN35113Day Zandra Y · Boise, IDN35115Stern Gary · Yuma, AZN3511HAvmd LLC · Houston, TXN3511LPatty Brent A · El Dorado, KSN35120Hillard Mark L · Gettysburg, PAN35122Riggs Charles A · Pembroke Pines, FLN35128Lambo Air LLC · Springtown, TXN3512HR & D Plane LLC · Longwood, FLN3512XTaylor Logan · Live Oak, CAN3513HTurbett Robert E · Penfield, NYN3513LDuden Brett R · Golden, CON35143Premier Jets Inc · Hillsboro, ORN35144Hofer Chris A · Tea, SDN3514LFlying Horseman Ranch LLC · Stuart, VAN3514QReed Daniel E · Wentzville, MON35151Aac Leasing LLC · North Ferrisburgh, VTN35158Pearce Henry J · New Baltimore, MIN3515LBorchers Bruce A · Scotts Valley, CA
Back to AD 80-25-07 R1