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.
N493JPRadtke Michael K · Mesilla, NMN493MAGreat Planes Aviation Inc · Rochester, MNN493RMRaritan Valley Flying School · Princeton, NJN493SHForsman David G Co-Trustee · South Haven, MNN49404Central Virginia Aviation Inc · North Dinwiddie, VAN4940EFlyright Aviation Inc · North Las Vegas, NVN4940FJackson Christopher M · Clearwater, FLN4940GN4940g LLC · Portsmouth, NHN4940LDrown William K · Columbus, OHN4940UBoard Of Regents Of The University Of Oklahoma · Norman, OKN49417Rich John E · Dunnellon, FLN49419Ds Flight Services LLC · Battle Ground, WAN49423Johnson Shem E · Bonners Ferry, IDN49424Xin Han Aviation LLC · Atwater, CAN4942HFlorida Flyers Flight Academy Inc · Saint Augustine, FLN49434943 LLC · Kalispell, MTN49432Northshore Group LLC · Wilmington, DEN49434California In Nice Inc · San Jose, CAN49438Crickmer Charles C · Overton, NVN49439Wisconsin Aviation Four Lakes Inc · Madison, WIN4943LBonus Kurt · Wind Lake, WIN4943ZBlackford Robert G · Mt Airy, MDN49447Wings Over Texas Holdings LLC · Denton, TXN4944LWilson Zane D · Fairbanks, AKN4944VDavies William T · Auburn, WAN4944ZHoppes Larry J · Springville, INN49455Above All Aviation Inc · Goleta, CAN4945JAsher Academy · Cameron, TXN4945LAlahmadi Hussein I · Avon, CTN4945ZWillis James · Pelham, ALN49461Blue Sky Aviation LLC · Watkins, CON4946BTippetts Kelly · Richmond, KSN4946LAndrews University · Berrien Springs, MIN4946TElite Fleet Jacksonville LLC · Jacksonville, FLN49471Aeroquest LLC DBA · Olive Branch, MSN4947GRiya Aviation LLC · Tracy, CAN4947JElite Fleet LLC · Spofford, NHN4947LAmoth Dallas V · Bonners Ferry, IDN4947ZSatreaas Kenneth A · Verona, NDN4948Andersen Bret E · Chugiak, AKN4948BKrause Aviation LLC · Geneva, ILN4948GTrece Inc · Adair, OKN4948ZSenn Joshua · Depauw, INN4949GFalcon Aviation LLC · South Saint Paul, MNN4949LLim Young Keun · Carthage, MON4949MCorben Sport Planes Museum LLC · Toccoa, GAN4949ZPeeples Ryan · Folkston, GAN494ABGluff Alan D · Franklin, INN494AMOsprey Holding Company LLC · Foley, ALN494DSBeulah Ltd Trustee · Wilmington, DE
Back to AD 90-04-06 R1