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.
N1740FBecton Richard A · San Antonio, TXN1741CWitt William A · Ennis, MTN1741MWolfehagen Paul B · Phoenix, AZN1742FMarsteller Bruce Paul Jr · Greensburg, PAN1742VGalion Air Inc · Galion, OHN1743FLittle Bird Airways LLC · Hamburg, NYN1743RChronicle Aerospace Inc · Wilmington, DEN1743VRegistered aircraftN1744XDodson International Parts Inc · Rantoul, KSN1745FClary David D · Elk Grove Village, ILN1745RFiske James K · North Andover, MAFirst renewal noticeN1746CGreen Gary Dale · Mccarthy, AKN1746RSky West Aviation Inc Trustee · Albuquerque, NMN1746ZThompson Nathan G · San Antonio, TXN1747BDgpiper · Sheridan, WYN1747CConatser Patrick M · Homeland, CAN1747FSmith Jason F · Ronkonkoma, NYN1747MMcmillan James D · Abilene, TXN1747QAleyda Aviation LLC · Berlin, NJN1747RFite Rodney Edward · San Lorenzo, CAN1748FManning Malcolm · Senatobia, MSN1748RNorthstar Holdings LLC · Anchorage, AKN1748UIliamna Air Taxi Inc · Iliamna, AKN1748ZRanz Douglas R · West Bloomfield, MIN1749QScott Andrew F · Beaufort, SCN1749UFreshwater Adventures Inc · Dillingham, AKN1749VVance Nicholas D · Bluffton, OHN174AAdkins Charles D · Apopka, FLN174DSSky West Aviation Inc Trustee · Albuquerque, NMN174DVVosters Gary A · Nevada City, CAN174GPLittle Terry J · New Port Richey, FLN174HLarsen Kevin L · Firth, IDN174HAKlin Trin Collectibles LLC · Downers Grove, ILN174JPGeary Michael Fredrick · Seguin, TXN174LSN174ls LLC · Middlebury, CTN174SFTaylor Thomas R · Lenoir, NCN1750FLeggett Lee D · Murfreesboro, NCN1750MChristensen Del A · Mattawa, WAN1750RShort James B · Anchorage, AKN1750URenfro Michael W · Bethel, AKN1751CFeaga Charles C Jr · Abbot, MEN1751RB&E Flying LLC · Morse Bluff, NEN1752CJarvis Jerry · Big Lake, AKN1754USutton Aircraft Salvage LLC · Palmer, AKN1754VAviation Specialist Inc · Apison, TNN1754XWest Alabama Lime Co Inc · Livingston, ALN17559Barnhill Eric J · Seneca, SCN1755CSutton Aircraft Salvage LLC · Palmer, AKN1755FSummit Aviation LLC · Belton, SCN1755RMchugh Charles D · Gilbert, AZ
Back to AD 97-01-13