AD 97-01-13
Registered aircraft · 54,837
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:97-01-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:97-01-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:97-01-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:97-01-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.
N2139FCrow Brian M · Oakesdale, WAN2139GSoarmates LLC · Missoula, MTN2139RShaw Gregory A · West Richland, WAN2139XAerometrix LLC · Lino Lakes, MNN213ANCalifornia In Nice Inc DBA · San Jose, CAN213BGUpstate Flyers LLC · Woodruff, SCN213JDS&C Vending LLC · Scottsbluff, NEN213LAJet Rider LLC · Middletown, DEN213MBNational Tax Relief Inc · Riverside, CAN21401Sterling Steven G · Richland, WAN21402Hester James Timothy · Fayetteville, GAN21403Bering Capital LLC · Anchorage, AKN21404Usglap · Fort Morgan, CON21405Brushwood John W · Coshocton, OHN2140GBoger Malcolm L · Dickens, TXN2140JHardin County Aviation LLC · Kountze, TXN2140QAtlantic Beach Flyers LLC · Atlantic Beach, FLN21414Flyboys Flying Club LLC · Pawleys Island, SCN21416Campbell David Lloyd · Fredericksburg, TXN2141FHill Henry M · Sleetmute, AKN2141GFreiheit Larry · Clinton, MON2141QNeuman Allen D · Sanger, TXN21421Paul Janet K · Beaver Island, MIN2142QLichtenberg Jeffrey L · Brookfield, MON21430Burns Preston · Spruce Pine, ALN21445Woody Dwain F Trustee · Lubbock, TXN21446Ham Todd O · Opdyke, ILN2144RButterfield Stephen · Nampa, IDN2144ZBeerle Brion J · Anchorage, AKN21450Brant Gary E · Salisbury, PAN21453Super D Electric Inc · Coeur D Alene, IDN21455Drewett Edward A · Many, LAN21457Registration Pending · Deland, FLRegistration pendingN2145GGraham William F III · North Wilkesboro, NCN2145QErnstes William L · Greensburg, INN2145YRegistration Pending · Spokane, WARegistration pendingN21461Acme Aviation Inc · Lake Charles, LAN21462Fly Man LLC · Waxhaw, NCN21465Clary Kenneth W Sr · Huntsville, TXN2146QMcdonald Anthony Robert · Brookside, UTN21472Registered aircraftN21474Alexander David L · North Pole, AKN21475Austin Police Dept · Pflugerville, TXN21477Frizzell Richard W Jr · Blacksburg, VAN2147YEast Carolina Aviation LLC · Camden, NCN21485Dipzinski Victor L · Clio, MIFirst renewal noticeN21487Millennial Flight LLC · Kalispell, MTN21488Mission Hardware LLC · Savannah, GAN2148GMissildine Ronald E Trustee · Simi Valley, CAN2148QMorten Jesse L · Larimore, ND
Back to AD 97-01-13