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.
N6638LNewby Danny A · Mc Leansville, NCN6638WTugmon Danny · Locust Grove, OKN66399Acord Aviation Co L L C · Chandler, OKN6639DBig Bend Community College · Moses Lake, WAN6639JColoski Dennis J · Marlton, NJN663ABBald Allan D · Alton, NHN663AFSnelling Peter G · Thornton, PAN663BFFoster Robert B · Erie, PAN663DHEmig Terry · Casa Grande, AZN663DSButler Raymond · Port Lavaca, TXN663DXSouthtec Inc · Wilmington, DEN663GGreatest Generation Naval Museum · Colorado Springs, CON663GMMitchell David · Carrollton, GAN663KSAnderson Brian W · Owatonna, MNN663NDUnd Aerospace Foundation · Grand Forks, NDN663RTRaiders Tigers Flying Club Inc DBA · Houston, TXN663RVPlaxco Mitchell O · Huntsville, ALN663SMMacmoyle Scott · Blairstown, NJN663WTSkywest Leasing Inc · St George, UTN663WWWinters Jacky L · Nashville, TNN66405Mh Aviation LLC · Foster City, CAN6640HSolis Aviation LLC · Carroll, OHN6640JHeesch Donald · Nunn, CON6640VCarlsbad Raceway Corp · Hemet, CAN6640WAldrich David G · Naples, FLN6641JStratus Business Development LLC · Nashua, NHN6642JFive By Ten LLC · Loveland, CON6642UCrawford Daniel G Trustee · Dryden, MIN6642WBrown Kevin D · Saint Louis, MON6643JJohnson Steve · Attleboro, MAN6643WWeiss Stephan T · San Jose, CAN66442Presby Aire LLC · Berlin, NHN6644MSierra Lima Aviation LLC · Riverton, UTN6644ZKing Jonathan R · Palmer, AKN6645JMcdonald Neill F Jr · Fairfax, VAN6645UFreemont Investors Inc · Bainbridge Island, WAN6645WHolman Robert S · Delta, UTN6646HIowa Great Lakes Flyers Inc · Cheyenne, WYN6646JNoize Farm Inc · Cheyenne, WYN6646WCordova Jesse · Raymore, MON6647KShackelford John S Jr · Roanoke, TXN6647UMouton Charles J Jr · Gladewater, TXN6647WPanama Truck Line LLC · Florissant, MON6649JBowline Ray D · Salina, OKN6649UKuykendall William · Yantis, TXN664AKWarren John · Homer, AKN664FLElon Aviation LLC · Burlington, NCN664JFFarrell Jeremiah E · Burnsville, MNN664KSStormont Dylan · Xenia, OHN664PBThomas Anthony Robert Jr · Frederick, MD
Back to AD 90-04-06 R1