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.
N4019ZPercy Nolan C · Saint Francisville, LAN401ADAlexander Brad K · Melissa, TXN401BJJohnson William L · Union City, INN401CDMccartney Terry A · Spirit Lake, IDN401DKBuford Copter Co LLC · Colorado City, TXN401DSDelaware State University · Dover, DEN401DTKairos Holdings LLC · Huntsville, ALN401FLRinaldi Isaac Paul · Richardson, TXN401GLUlrich Lee · Rio Linda, CAN401HWPiper Aircraft Inc · Vero Beach, FLN401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeN401KCWellman Russell L · Danville, VAN401LALee Hunter · Colorado Springs, CON401LDBrady Kevin J Trustee · Afton, OKN401LSEl Paso Aero Inc · El Paso, TXN401PASkywest Leasing Inc · St George, UTN401PKJones Roderick H DBA · Thomasville, GAN401RSawyers Ron S · Hayden, IDN401RHTofte Shawn A · Lewis Center, OHN401TCPrecision Ag Air LLC · Pendleton, INN401VFSchoenberger Neil J · Saint Petersburg, FLN401ZAlpha Tango Aircraft LLC · Wilmington, DEN4020DInnovative Design Group Inc · Watkinsville, GAN4020XCox Nathaniel E · Ocala, FLN4020ZFinch Ernest B · Anchorage, AKN4021Nighthawk N8231g LLC · Pompano Beach, FLN4021BElrod Brent W · Cashion, OKN4021HToth Richard C · Tinley Park, ILN4022MBeautte James Edward · Fairland, OKN4022ZKahn Steven H · Port Alsworth, AKN40230Harris Dan C · Rockford, TNN40234Mallow David N · Rio, WVN40238Blue Ridge Community College · Weyers Cave, VAN4023FFreese Barry L · Leonardtown, MDN4023LCenteno Ramon A · Oak Creek, WIN4023MObrien William D · Duluth, MNN4023XRhodes Stephen · Marion, NCN4023ZLunenschloss Michael L · Anchor Point, AKN40246Harper Matthew C · Anchorage, AKN4024JKeleti Laurie · Lakewood, NJN4024MSale Reported · Monroeville, ALSale reportedN4024XFaussett Thomas J · Greenville, MIN4024ZBrown Timathy S · Wasilla, AKN4026HParker Gerald L · Stevensville, MDN4026NSeiger T W DBA · Medford, ORN4026XAlderin Charles A · Center, NDN4027HEhrenfelt Linda Mae · Pierre, SDN4027MBoyle Fred W · Cape May, NJN4027NC2c LLC · Chesterfield, MON4027PAg Air Squadron One LLC · Saint Joseph, IL
Back to AD 90-04-06 R1