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.
N515TBMhoc LLC · Pensacola, FLN515TLLumpkin Theodore G III · Inglewood, CAN515TRRabaut Charles P · Oceanside, CAN515UDTumbleweed Leasing Company Inc · Salt Lake City, UTN515VHGrabeklis Jay · Dallas, TXN515VTBud E Aero Inc · Franklin Square, NYN515XCPlane Fun Inc Tr (Trustee) · Snellville, GAN515ZMcrae David B · Advance, NCN5160Historic Aircraft Restoration Museum · Maryland Heights, MON5160ELeading Edge Flight Academy LLC · Bend, ORN5160HNiemi Danny L · Osage, MNN5160LMikesell Bruce A · New Madison, OHN5160RTownley Wren Adam T · Orwell, VTN5160SJohnson Matthew N · Redgranite, WIN5160XCulver Deborah M · Anchorage, AKN5160ZWend Roger W · Charlotte, MIN51614Stillwater Flyers LLC · Columbus, MTN51616Stardust Aviation LLC · Farmingdale, NYN5161LGonzalez Ramiro Z · Homeland, CAN5161MSamora Bobby · Corona, CAFirst renewal noticeN5161SCapen Leasing LLC · Palm City, FLN5161TStuart M Davis Inc · Rice, WAN5161XSlease Brian D · North Pole, AKN51627Warren David T · Mobile, ALN5162BK D Helicopters Inc · Shingleton, MIFirst renewal noticeN5162FLosasso Michaela Marie · Scottsdale, AZN5162KHensley Bradley S · Lake Charles, LAN5162LBlue Gecko LLC · Sheridan, WYN5162MCorcoran Thomas A · Braintree, MAN5162PHorton Melody A · Diamondhead, MSN5162REllis Harvey Airport Inc · Guthrie, OKN5162SStramer Douglas W · Hazelton, NDN5162TAdvanced Insulation Enterprises LLC · Calhoun, LAN5162XMcmorries Kyle Patrick · Nacogdoches, TXN5163DHaddix Stanley D · Hagerhill, KYN5163GEvans Gary S · Independence, ORN5163LBowyer Richard A · Ormond Beach, FLN5163PReynolds David A · Blacksburg, VAN5163SValley Fliers Flying Club · Auburn, WAN5163THendrickson Duane J · Rocklake, NDN5163UValor View Aviation LLC · Midland, TXN5163VKopacz Thomas · Glen Flora, WIN5163WSeaton Ryan W · Savannah, TNN5164EWilliams Kevin J · Giltner, NEN5164MChristiansen Aviation LLC · Wilmington, DEN5164PUpton John B · Lakeland, FLN5164SNorthern Sky Aviation LLC · Harbor Springs, MIN5164TLeonard Bruce Danield · Spokane, WAN5164WMorning Aviation LLC · Altoona, PAN5164ZEast Texas Aircraft Engines LLC · Palestine, TX
Back to AD 90-04-06 R1