AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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.
N93943Alaska Aircraft Leasing LLC · Silverdale, WAN9394CRhr Management Inc · Bancroft, WIN9394DRed Baron LLC · Middletown, DEN9394HJohnson Chester F III · West Ossipee, NHN9394UYu Hermon Lemuel C · Mays Landing, NJN9394XBlue Sky Flyers Inc · Punta Gorda, FLN9395ARothacker Aviation LLC · Chester Springs, PAN9395BChristiansen Aviation LLC · Wilmington, DEN9395HInosculation Air LLC · Summerville, SCN9395NUnited States Department Of Interior · Boise, IDN9395XCoyote Air · Austin, TXN9396AFortune Michael W · East Dublin, GAN9396BRhyshek John C · King Salmon, AKN9396HHaley Robert Jay · Livermore, CAN9396UMullen Randy R · Pasco, WAN9396XGonzalez Leopoldo · Laredo, TXN93974Just Plane Stupid LLC · Loveland, CON9397ABarron Aviation LLC · Perry, MON9397HFlight World Inc · San Juan, PRN9397UWelch Kerry D · Alpine, UTN93980Pruitt Hugh A · Ardmore, OKN93989Sunrise Aviation Inc · Ormond Beach, FLN9398ATraver Larry L · Sturgis, SDN9398BBishop Daniel R · Bettendorf, IAN9398CHolden Daniel N · Anacortes, WAN9398UShouling & Philip Enterprise · Lancaster, CAN9398XRegistration Pending · Chillicothe, OHRegistration pendingN9399ABarron Aviation LLC · Perry, MON9399BSamoilenko Sergey V · Hillsborough, NCN9399CHansen Sean J · Anchorage, AKN9399E9 Echo LLC · Muskogee, OKN9399MGrant Aviation Inc · Anchorage, AKN9399XStorm Flying Service LLC · David City, NEN939ACFlorida Flight Training Center Inc · Venice, FLN939RLHintzsche Roger E Trustee · Dekalb, ILN93BZMoreno Joseph L · San Diego, CAN93ETGhatan Farhad · Friday Harbor, WAN93FMAms Aviation LLC · South Bend, INN93HBVranes Michael · Zephyr Cove, NVN93HPAxe Capitol Inc · Lake City, FLN93JESibora Group LLC · Gilbert, AZN93JSNeptune Aviation Services Inc DBA · Missoula, MTN93KKMonmouth Area Flying Club · Lakewood, NJN93LSutton Aircraft Salvage LLC · Palmer, AKN93LCCl Max Inc · Wilmington, DEN93MBNorthwoods Air LLC · Orono, MEN93MMChristenson Robert E · Anacortes, WAN93PSVanderflute Scott L · Lakewood, WAN93QDurtschi James Werner · Sisters, ORN93THAir Chief LLC · Granbury, TX
Back to AD 87-20-03 R2