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.
N355TCRoss Shannon M · Boise, IDN355VAVictory Aviation Club Inc · Hamilton, OHN355WBWhite River Aviation LLC · Midway, ARN355YPlussa Mark George · Clermont, FLN355ZRoeder Richard E · Emmett, IDN35608Scenic Mountain Air Inc · Moose Pass, AKN35609Unruly Passengers LLC · Piedmont, SCN3560ECrawford James M · Sparta, MIN3560FAdams Chris · Braselton, GAN3560PRichardson Billy J · Friendswood, TXN3560UMcmaster John F · Wichita, KSN3560VAmdor John E · Harlan, IAN3560XCarey Brad Eugene · Grapeview, WAN3560YTriple J&M Flying LLC · Guymon, OKN3560ZBolding Ronald B · Aguila, AZN35615Stoddart Eugene T · Lodi, CAN35617Britt David J · Somerset, KYN35618San Juan Flyers LLC · Friday Harbor, WAN3561QSales Joe H · Seminole, TXN3561WSchulz Beverly A · Merrill, WIN3561YDk Futures LLC · Reno, NVN35621Loza Guillermo · Acton, CAN35623Rtd Aviation LLC · Hillsborough, NJN35626Eubanks Mitchell N Jr · San Antonio, TXN35627Wright William F · Hobbs, NMN35628Plane Junkies LLC · Dover, DEN35629N35629 LLC · Brunswick, GAFirst renewal noticeN3562DXin Han Aviation LLC · Atwater, CAN3562FHexd Medical · Rexburg, IDN3562GTroy Oakland Pilots Flying Club Inc · Troy, MIN3562UPrairie Aviation Of Hamilton Inc · Corvallis, MTN35632Briden Gordy D · Stacy, MNN35638Newberry Ernest B Jr · Crawfordville, FLN3563EPang Clifford S · Coppell, TXN3563FParker Layne T · Gustavus, AKN3563NHill Michael T · Cedarpines Park, CAN3563QKd3262 LLC · Downers Grove, ILN3563UWest Robert M · Lake Oswego, ORN3563YHegge Luke · Pine City, MNN35644Pratt Sanders · Renton, WAN3564DKar Aviation LLC · Indialantic, FLN3564EGenerals International Inc · Red Oak, TXN3564NAbbott Aircraft Sales And Service LLC · Holts Summit, MON3564USkylane LLC · Luling, LAN3564WWemyh Air LLC · Krum, TXN35651Schubnell Ryan A · Avondale Estates, GAN35656Hew Llp · Beresford, SDN35659Steele Aviation Inc · Walnut Cove, NCN3565FKlosowski Mark Kevin · Lisbon, NYN3565JKendrick Ross Mitchell · Sycamore, GA
Back to AD 2007-04-19 R1