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.
N43661Gordon James R · Greenwood, INN4366HShank Paul L · Gaithersburg, MDN4366JRegistration Pending · Daytona Beach, FLRegistration pendingN4366MCline Robert A · Clarkston, WAN4366RHyland Mark R · Poland, MEN43671Rush Micah N · Salem, ORN4367GDimenno Phillip A · Windermere, FLN43685Horizon Aviation LLC · Brooks, GAN43688Blue Skies Aircraft LLC · Kalispell, MTN4368HMuskogee Airmen Inc · Muskogee, OKFirst renewal noticeN4368NGeary Jared A · Anchorage, AKN4368TWillgress Edwin R Jr · Mundelein, ILN4368UBorges Jr Frank · Angwin, CAN4368VWaunch Robert L Trustee · Eastsound, WAN43690Fly Twin Commanche LLC · Peoria, AZN43693Milazzo Robert J · Sudbury, VTN43695Kinney Ian · Calhoun, LAN4369AWinston William A · Bremo Bluff, VAN4369NJ J Bagley Transportation Co LLC · Chalfont, PAN436ACKimmel Aviation Insurance Agency Inc · Greenwood, MSN436DBPro Check LLC · Salt Lake City, UTN436GCareer Pilot Training LLC · Wilmington, DEN436HOllila Dale G · Buckeye, AZN436JEAccomazzo Kevin E · Charlotte, NCN436NDFly By Knight Inc · Hammond, LAN436PABird Acquisition LLC · Phoenix, AZN436PDDibartolo Michael · Wasilla, AKN436RMRocky Mountain College · Billings, MTN436SCAb Prop Plane I LLC · Metairie, LAN436SKTds Property Holdings LLC · Gilmer, TXN436SPHillsboro Aero Academy LLC · Hillsboro, ORN43700Aviation Career Enrichment Inc · Atlanta, GAN43707Namah LLC · Gadsden, ALN4370AMacdonald Kenneth A · Willow, AKN4370JDreyer Elwain C · Cardington, OHN4370KHodges Berry Farm LLC · Willacoochee, GAN4370MDunker Arden J · Boise, IDN4370NThunderbird Aviation · Bloomington, MNN4370RSkar Paul R · Londonderry, NHN4370XMcguirk Michael S · Johnstown, PAN43711Airmart Inc · Lexington, KYN43717A Comet Aviation LLC · Altus, OKN4371AWest Transport LLC · Anchorage, AKN4371DKakurata Shinya · Portland, ORFirst renewal noticeN4371HLazor Ron · Middlefield, CTN4371ZChow Kamahele Taylor · Homer, AKN43721Penn Flight School LLC · Quakertown, PAN43727Hunt Kenneth N · Santa Rosa, CAN4372APex John A · Chugiak, AKN4372HMathys Greg A · Marysville, OH
Back to AD 90-04-06 R1