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.
N40VXHarder Steven R Trustee · The Sea Ranch, CAN40VZJump Jet LLC · Fort Worth, TXN40WFGrennell Brian M · Euless, TXN40WNRider Rebecca L · Hyde Park, NYN40XEFly Diamond Da40 N40xe LLC · Kalispell, MTN40XPRegistration Pending · Dallas, TXRegistration pendingN40YLMeggers Roger D · Baker, MTN41007Registered aircraftN4100FGoldberg Mark · Massapequa Park, NYN4100GRegenald Michaud Aviation LLC · Willows, CAN4100PValley Flying LLC · Stuarts Draft, VAN4100YLofton Charles T · Georgetown, MNN4100ZMountain Escape LLC · Pullman, WAN4101JRichardson Howell · Gilbert, AZN4101YBower Gary R · Miranda, SDN4102HForeman Guy W · Valparaiso, INN4102PDoran Jeffrey T · Westerville, OHN4103Port Townsend Aero Museum · Port Townsend, WAN4103MMills Air Service Inc · Marstons Mills, MAN4103NKarpik Joseph Paul · Floodwood, MNN4103PLumley John J · Delray Beach, FLN4104Lewis Charles W · Newalla, OKN4104PSpooter Air II LLC · Willis, TXN4104XBandy Carla Sr · Texarkana, TXN4104YBurgett Gary · Galena, AKN4104ZZelina William B III · Fort Greely, AKN4105Rush David T · Durham, NCN4105HBonanza Valley Air LLC · Alexandria, MNN4105MMameli Laurie K · Thomaston, GAN4105ZMccaughey Steven A · Winter Haven, FLN4106JFlander Donald D · What Cheer, IAN4106NGioia Matthew M · Stafford, VAN4106XRossiter Andrew J · Vancouver, WAN4106ZJohnson Royce D · Clinton, ARN41071Zabinski Ted W · Voorheesville, NYN4107MBeckham John T · Steelville, MOFirst renewal noticeN4107NWest Main Auto Sales Inc · Tupelo, MSN4107PTm Aero Marine Inc · North Miami, FLN4107XRedsun Oren Daniel · Fairfield, CAN4107ZMissaukee Aircraft Leasing LLC · Cadillac, MIN4108ASwinehart Frank E · Lock Haven, PAN4108JMetoyer Eric D · Yukon, OKN4108ZRamstad Trygg J · Anchorage, AKN4109HSchamber Thomas D · Oklahoma City, OKN4109NRoss George H · Delano, MNN4109ZAlf Robert R · Elkhorn, NEN410BBBranscomb Brian K · El Granada, CAN410BPWeiss Michael K · Paige, TXN410BWHeffelfinger Darin W · Sterling, ILN410EKGandy Donald T · Weatherford, TX
Back to AD 90-04-06 R1