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.
N79224Wolstenholme James L · Doylestown, PAN79227Elkins Pilots Club · Elkins, WVN79228Lowcountry Flying Club · Moncks Corner, SCN7922NMemo Air Services LLC · San Antonio, TXN7922WVouk Frank E · Firth, IDN7922YSuhrie Mark A · Oneida, KYN79233Sweeney Kathleen R · Hollister, CAN79234Aig Aeronautics LLC · San Juan, PRN79238Flightclub LLC · Jacksonville, FLN79239Custis James G · Friday Harbor, WAN7923BFishel Todd · Nineveh, INN7923LTolliver Richard R · Amery, WIN7923NGcc Aviation LLC · Elberton, GAN7924Staple K Aviation LLC · Queen Creek, AZN79241Stanley Aero Club Gastonia Inc · Belmont, NCN79244Wings Over Texas Holdings LLC · Denton, TXN79246Farrv LLC · Ogden, UTN79248San Hui Foundation · Denver, NCN79249Wings Over Texas Holdings LLC · Denton, TXN7924GHendrickson Burke · Kent, WAN7924HBourland Kenneth C · Waller, TXN7924WStumpner Van H · Warsaw, MON79255Angel Piper A · Mount Airy, NCN79256Mcdaniel Donald L · Tishomingo, OKN7925HMedary Thomas A · Corpus Christi, TXN7925JChurchill Scott · Le Sueur, MNN7925LAdams August G · Southport, NCN79263Warner Richard M · Yellow Springs, OHN79264Vande Griend Scott M · Springfield, MON79268Hunt-Thornton Trevon · Aurora, CON79269Thomas Michael J · Eagle River, AKN7926GSpencer Aviation Inc · Delaware, OHN79270Jb Flight Services LLC · Carlsbad, NMN79274Olson Karl C · Bethel, MEN79275Briggeman Benjamin Andrew · Indianapolis, INN79276Burkholder Bruce B · Rockingham, VAN79277Foerster Keith A Trustee · Mound, MNN7927WFlight 4 U LLC · Lakeport, CAN79283Bradley Flying Association · Peoria, ILN79284Wright William T · Lenoir, NCN79286Aberdeen Pilots LLC · Boerne, TXN7928CCash Management Consulting LLC · Granite Springs, NYN7928LCox Robert Etan · Flippin, ARN7928YW Carney LLC · Ocala, FLN79296Ennis Michael J · Eminence, MON7929WStevenson Robert F · Wilmington, DEN7929YMasek Lawrence J · Cuyahoga Falls, OHN792AMeridian Aircraft LLC · Wilmington, DEN792BHuffman Myron · Felda, FLN792LRussell Robert Bruce · Clayton, GA
Back to AD 90-04-06 R1