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.
N8317TCalgonaire LLC · Seminole, TXN8317VLynch Gerald C · Collinsville, OKN8318Rickey Donald Leslie · Murfreesboro, TNN83180John Cox LLC · De Witt, NEN8318CAviator Jet LLC · Dover, DEN8318EJust Planes Inc · Hobbs, NMFirst renewal noticeN8318HParra Henry A Torres · Weston, FLN8318QPenn Flight Academy LLC · Quakertown, PAN8318RAir Wave Holdings LLC · Porter, TXN8318VVetter Brent E · Helena, MTN8318YMaverick Air LLC · Wildwood, MON8319LLaudon Piper C · Anchorage, AKN8319WBlaker Martin O · Rough And Ready, CAN831APlane Fun Inc Tr Trustee · Snellville, GAN831AC831ac Aero LLC · Ogden Dunes, INN831AKJablonski Francis R III · Byron Center, MIN831ASChmiel Edward C · Barrington, ILN831BFHuddleston Edward L · Oaktown, INN831BRAir Future Airways Corp · Miami, FLN831GBDievendorf Gerry T · Columbia, SCN831GRGrahn James A · Las Vegas, NVN831KTPilot Network Flyers LLC · Bastrop, TXN831LBWedekemper Steven E · Brighton, MIN831MNSallee William T · Sylvania, OHN831NDCirrus Aviation Inc · Sarasota, FLN831NQEslinger Carl W · Chouteau, OKN831PMAvier LLC · Beverly, MAN831RHHanson Paul D · Evansville, INN831SHHutchison Eugene W · Armagh, PAN831TSWingsleasing LLC · Wichita, KSN831VZMelbourne Flight Training LLC · Melbourne, FLN83208Rothrock Cara J · Streator, ILN8320AMendez Leonel Jr · Corpus Christi, TXN8320CRiffle Bruce H · Chesterton, INN8320VThurman Randall N · Mcminnville, ORN8320WOracle Aviation LLC · Omaha, NEN8320YKling Aviation Inc · Friendswood, TXN8321CJackson Blane · Beaufort, NCN8321HJust Plane Fellas LLC · Omro, WIN8321LArevalo Gilbert Jr · Loranger, LAN8321MFox Two LLC · Camino, CAN8321PSmoketown Helicopters LLC · Smoketown, PAN8321RThompson Grady R · Athens, ALN8321TRobinson Denise · Middletown, CTN8321WWeighman David R · Battle Creek, MIN8322EHorton Ernest J III · Galveston, TXN8322SAtp Aircraft 4 LLC · Wilmington, DEN8322V11 Point Aviation LLC · Alton, MON8322WLickteig Eric Kirk Trustee · Ellensburg, WAN8322YDayhoff Miller Alice J · Springfield, OH
Back to AD 90-04-06 R1