AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N751MBSerbu Mark S · Tampa, FLN751MDVaughn Billy D · Poteau, OKN751MLQueensland Air LLC · Chicago, ILFirst renewal noticeN751PCVenture North Aviation LLC · Cloquet, MNN751SPHagele Aviation LLC · Hillsboro, ORN751TSFly-X LLC · Columbus, NEN751WTVenture North Aviation LLC · Cloquet, MNN751WWVicentin De Oliveira Ricardo · Winter Garden, FLN751YZVenture North Aviation LLC · Cloquet, MNN752Usda Aphis Ws Atoc · Cedar City, UTN75200Rockwell Aviation LLC · Aventura, FLN75202Plane Nonsense Inc · Middletown, DEN7520DPerron John J · Lodi, WIN7520RN7396w 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, IDN7522RRed 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, OHN7523GTriple J Aviation LLC · Mcconnelsville, OHN7523JWilson Gregory Robert · Templeton, CAN7523KRichardson Joe W · Ennis, MTN7523RFlorida Flyers Aviation LLC · Deltona, FLN7523VTwc Aviation Services LLC · Merritt Island, FLN7523WHarned Anthony L · Port Saint Lucie, FLN7523YBarry Patric · Laguna Hills, CAN75248Leydsman 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, FLN75254Meyer Larry · Brush, CON75255Jackson Christopher · Clearwater, FLN7525DRedhanded LLC · Dover, DEN7525HN7525h LLC · Lincoln, VT
Back to AD 90-04-06 R1