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.
N424DAMalmin David L · Cumming, GAN424FLNeihart Randy L · Fontana, CAN424FPUtah State University · Logan, UTN424KCCoontz James K · Melba, IDN424LSQualitair LLC Trustee · MichelstadtN424MKMkt Aviation LLC · Mankato, MNN424MROsborne Clarence Michael · Madison, MSN424PASkywest Leasing Inc · St George, UTN424RBMuse Raymomnd P · Nacogdoches, TXN424RDTorin Thomas Roschinger · Anchorage, AKN424RHRegistration Pending · Ogdensburg, WIRegistration pendingN424RKTerry Ryan · White Lake, MIN424RNKraut Brian J · Green Cove Springs, FLFirst renewal noticeN424RWWestphal Jon A · Menomonie, WIN424SCThread Head Quilting LLC · Anchorage, AKN424SEOliveira Jean Alves · Bedford, MAN424SPPft Inc · Wilmington, DEN424TFHalf Penny Hangar Inc · Houston, TXN424WSkywarrior Flight Training LLC · Pensacola, FLN424WGClement Victor T · Ord, NEN424WMMorrison Jeffrey A · Williamson, GAN424WTLumberton Air 1 LLC · Mount Laurel, NJN42502Stackhouse Mark A · Orwell, OHN4250HMincher Charles Mf · Dillingham, AKN4250JLeasing Systems Inc · Gallatin, TNN4250QTice Evan L · Seattle, WAN4250TKennedy Elvis L II · Hoover, ALN4251ERobbins Warren N · Chandler, AZN4251JBentley Dennis L · Muscadine, ALN4251MChapin Dean H · Cambridge, NYN4251ZCarroll Wilmer Lee · Kerrville, TXFirst renewal noticeN4252FLunn James · Winchester, CAN4252HHoutz Allen D · Kenai, AKN4252MRobinson Eric C · Palmer, AKN4252QPoage Thomas F · Sacramento, CAN4252T9g LLC · Centerville, TNN4252ZJohnson Daniel J · Redding, CAN4253Herreman Brian J · Elkhart, INN4253PBowles Alan B DBA · Georgetown, TXN4253QFrog Av LLC · Brownstown, INN4253TBauman Luke A · Saint Ignatius, MTN4254PPetersen Clayton L · Albert Lea, MNN4254TGospel Legacy LLC · Dumfries, VAN4254ZEllingson Leslie B · Harwood, NDN4255THarding-Bridgeport LLC · Westlake, OHN4255ZBlake Michael R · Girdwood, AKN4256HJeffers Chadwick Ray · Glencoe, ALN4256MKcg Aviation LLC · Angola, NYN4256QBurnham Cessna N4256q LLC · Carr, CON4256TMarriott David D · Henderson, NV
Back to AD 90-04-06 R1