AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N7520DPerron John J · Lodi, WIN7520PRomo Victor Gerardo · Menifee, CAN7520RN7396w LLC · Coeymans Hollow, NYN7520YWendelburg Kevin R · Moreland, GAN75211Sikes Allen E · Hogansville, GAN75217Taughannock Aviation Corp · Ithaca, NYN7521DLaabs Francis C · Ames, IAN7521HKrochmal David R · Lancaster, PAN7521JDemarest Graham T · Dallas, ORN7521VLeslie Warren J · Sequim, WAN7521ZVeracity Aviation LLC · Seguin, TXN75229Krump David J · Frederick, MDN7522DCorbett Grant J · Nampa, IDN7522PXair LLC · El Cajon, CAN7522RRed Baron Flying Club LLC · Oneida, NYN7522WBaune Justin J · Hayden, IDN75230Aircraft Sales Inc · Canton, OHN75231Paris Air Inc · Vero Beach, FLN75232Changewater Equipment Services LLC · Washington, NJN75239Tumbleweed Aviation LLC · Janesville, WIN7523DRoss David R · Wakeman, OHN7523EFlying J Services LLC · Jourdanton, TXN7523GTriple J Aviation LLC · Mcconnelsville, OHN7523JWilson Gregory Robert · Templeton, CAN7523KRichardson Joe W · Ennis, MTN7523RFlorida Flyers Aviation LLC · Deltona, FLN7523TNovember Alpha LLC · Dover, DEN7523VTwc Aviation Services LLC · Merritt Island, FLN7523WHarned Anthony L · Port Saint Lucie, FLN7523YBarry Patric · Laguna Hills, CAN7523ZAmerican Ag Aviation LLC · Belden, MSN75242M&M Air LLC · Watkinsville, GAN75248Leydsman Wayne · Provo, UTN75249Steinle Michael · Smithville, NJN7524DGreene Robert M · Limestone, TNN7524FRobinson Robert L Jr · Homer, AKN7524GBrandywine Sky Ramblers LLC · West Chester, PAN7524HThree D Adventures LLC · Newfolden, MNN7524KBartel Gordon L · Anchorage, AKN7524RTiny Tin Aviation LLC · Groveland, FLN7524WN7524w LLC · Grand Ledge, MIN75252Homesky Johnathan Edward · Mcgregor, TXN75254Meyer Larry · Brush, CON75255Jackson Christopher · Clearwater, FLN7525DRedhanded LLC · Dover, DEN7525HN7525h LLC · Lincoln, VTN7525JFosdick Trevor · Aldie, VAN7525PStack Robert J · Aurora, CON7525RCallis Merle F · Lone Grove, OKN75269Smart James Tim · Spurger, TX
Back to AD 81-18-04 R2