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.
N78LLLawnchair Pilots Association LLC · Wilmington, DEN78MJTalley Patricia · Asheboro, NCN78MTBrady William P · Banner, WYN78MVWhittington Rankin A Trustee · Lenoir, NCN78NPHeaton Justin · Lufkin, TXN78NSRobertson Lester M · Hamilton, OHN78PDBryant Jerry L · Punta Gorda, FLN78PJRothrock John W Jr · Danville, INN78PPToman Gregory R · Caledonia, MIN78QBPandion Aviation LLC · West Chester, PAN78QPHilyer Bruce W Trustee · Seattle, WAN78RFFairchild Maxwell D · Morristown, TNN78RJUsaeroflight LLC · Greenville, SCN78RTMorris Coady C · Russell, KSFirst renewal noticeN78SEFlight Fundamentals Inc · Willcox, AZN78SKCleveland Gary J · Plymouth, INN78SWSidewinder Aircraft LLC · Yulee, FLN78TACti Aircraft Leasing LLC · Memphis, TNN78TGGardner Terrence L · Grassy Creek, NCN78TKFinseth Lowell J · Fountain, MNN78TMBowlin Ronald R · Camarillo, CAN78TXDragger Aviation LLC · Wildwood, MON78VLAdams Michael · Oxnard, CAN78VMPileggi Anthony · Leland, NCN78WARtd Aviation LLC · Hillsborough, NJN78WGBarros Da Costa Cristiano Manuel · Grand Forks, NDN78WSHjelmstad David J · Burnsville, MNN78WTCole Thomas Ed · White Settlement, TXN78YDoster Michael L · Nampa, IDN79000Kemmis Sidney C · Prophetstown, ILN79001Pau Hana Enterprises LLC Series IV · Boulder City, NVN79002Fremont Aviation Inc · Fremont, NEN79004Palmer Joe A · Meridian, IDN79009Birkholz Raymond J · Boulder, CON7900CSdd Aviation LLC · Thomasville, GAN7900GGreat Plains Enterprises LLC · Wilmington, OHN7900HMartin Robert C · Farmington, MEN7900WDiedrich Paul E · Fort Mill, SCN7900YLone Star Aircraft Holding Group LLC · Plano, TXN79012Brewer Jeremiah L · Eagle River, AKN79013Woods Michael F · Hamilton, NJN79014Fcs Aviation LLC · Lewisport, KYN79015Flying Weaners Inc · Jacksonville, FLN7901CFrost Aviation Alliance LLC · North Hollywood, CAN7901GRaines Adam D · Ridgewood, NJN7901YHinshaw Eric C · Lake Wales, FLN79021Smith Timothy C Trustee · Riverton, WYN79024Jwp Flying Services LLC · Chatfield, MNN79027Arrow North LLC · Missoula, MTN79028Jdc Aviation LLC · Upland, CA
Back to AD 90-04-06 R1