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.
N593SPFull Rudder Flyers LLC · Mesa, AZN593STN593st LLC · Bangor, MEN593VSchadle Alvan G · Soldotna, AKN59402Galloway Douglas A · Sandusky, OHN59403Worthy Gary L · Atwood, KSN5940DRunnin Rabbit LLC · Kalispell, MTN5940PSilver Arrows LLC · Beaverton, ORN5940UStrong Colin · Portland, ORFirst renewal noticeN5940ZMoore Roger W · Poinciana, FLN5941WCunningham James R · Collierville, TNN5941ZByler Jonathan P · Inman, SCN5942DFour For Flying Inc · Holyoke, CON5942HHendrickson Jacob N · Central, AKN5942LSimulation International Management Inc · Tulsa, OKN5942QBravo J Bravo Aviation LLC · Louisville, KYN5943EPlane Zane LLC · Stuart, FLN5943HPleiman Jeffrey S · Minster, OHN5943LBlackmore Marc A · Hilltop Lakes, TXN5943QFreeborn Andrew B · North Las Vegas, NVN5943URoth Larry · Marion, IAN5943WSallee Steven A · St George, UTN5944DBradley Dennis Michael · Myrtle Beach, SCN5944LHoover Charles J · Logansport, INN5944WFerguson Robert C · Cornelia, GAN5945DKline Paul R · Mapleton Depot, PAN5945HMccoy David L · Bear Creek, WIN5945WHensley Roger A · Rosamond, CAN5945XFarwell Theodore R · Orangeville, PAN5945ZThompson Neal R · Magnolia, DEN59463Kelsay Roger B · Hillsboro, ORN5946DInsite Design LLC · Indianapolis, INN5946UBlack Howard J Jr · Bethpage, TNN5946Z507 Flying Club Inc · Leetonia, OHN5947DPayne David J · Eagle River, AKN5947NGmm Records · Big Pine Key, FLN5947QMorales Nelson · Hendersonville, NCN5947WPierce Colby · Midland, TXN5948DHumble Servant LLC · Salem, WIN5948ETlt Legacy LLC · Fort Worth, TXN5948QKrull Lynn · Thompson, IAN5949DWick Marcel P · Warsaw, NYN5949HPierce Stephan L · Graham, TXN5949U5949 Inc · Boulder City, NVN5949WSutton Warren L · Loris, SCN594AMMaarouf Mike · Taylor Lk Vlg, TXN594CEBertsch Paul J · Houston, TXN594HKeading Helicopter LLC · Shoshone, IDFirst renewal noticeN594JWNelson Travis E · Richland, MTN594RSturgen Scott H · Moira, NYN594RVGreer Charles C · San Diego, CA
Back to AD 90-04-06 R1