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.
N82566Low James E · Fairbanks, AKN8256EWilliams Evan H · Sebastopol, CAN8256PHouse Terry J · Mountain View, ARN8256VZ-Tech Research LLC · Greenville, TXN8256WInland Northwest Flyers LLC · Spokane Vly, WAN8256XSkyriders Inc · Pocatello, IDN8256YPhill-Air Inc · Dover, DEN82577Sale Reported · Wasilla, AKSale reportedN8257GDraco Flight School Inc · Chino, CAN8257JGruber Larry E · Delphi, INN8257WHou Barry · San Marino, CAN8258JKenyon Travis · Phoenix, AZN8258LWiesner Loren A Jr · Cameron, WIN8258NK&G Transit LLC · Fort Mc Coy, FLN8258WWirkus Branden D · Apo, AEN8258YJohnson David C · Chisago City, MNN82591Cornia Mike D · Wasilla, AKN82598Foothill Aviation LLC · Iliamna, AKN8259BDunn Patrick E · Marthasville, MON8259GCappello Dave Allen · Cottonwood, CAN8259NAughenbaugh Timothy A · Iriquois, SDN8259TNsa Ops LLC · Kahului, HIN8259WMorrison Daniel S · Hershey, PAN8259YRyan Ferguson LLC · Sanford, FLN825ABAchord James D · Decatur, ALN825ALN825al LLC · Freeport, NYN825DEYouderian Kenneth E · Coupeville, WAN825ERFlying Aces Aero-Fleet Inc · Guyton, GAN825FGN825fg Corp Trustee · Wilmington, DEN825KBBrech Robert M · Greenbrier, ARN825KMHusky 5 Kilo Mike LLC · Houston, TXN825KSPlanelease LLC · Venice, CAN825MCC & M Aviation LLC · White Lake, MIN825PBPalm Beach Aircraft Services Inc · Lantana, FLN825PMKidd Paul C · Vestavia Hills, ALN825PTIcarus Flyers LLC · Richmond Hill, GAN825RVSmith Stephen C · Talent, ORN825SHJ L Loewen Md Sc · Niagara, WIN82600Hendrickson Ryan H · Gunnison, UTN82603Spain Benjamin D · Opelika, ALN82604Graves Frank C · Nocona, TXN8260NSundberg Nicholas William · Stevensville, MTN8260VRed Rifle Aviation LLC · Richmond, TXN8260YNew Peach Aviation LLC · Brooks, GAN82613Wammen Ranch Llp · Reva, SDN82617Cooper Holly B · Friendswood, TXN82618Lechner Burdette J · Kodiak, AKN82619Cherry Hill Aviation Inc · Freetown, INN8261ECtc Elevated LLC · Heppner, ORN8261GBaer Charles · Terre Haute, IN
Back to AD 90-04-06 R1