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.
N9835GPiedmont Flight Inc · Winston Salem, NCN9835JCrooks Curtis L · Truckee, CAN9835TVfr Ltd · Wilmington, DEN9836AMabry Dale C · San Antonio, TXN9836BSoulek Paul A · Spearfish, SDN9836CDominguez Robert R · Temecula, CAN9836GSchafhausen Mark G · Spokane, WAN9836HDouglas County Land Title Co · Douglasville, GAN9837GSouther Field Aviation Inc · Americus, GAFirst renewal noticeN9837HChristmas Aviation LLC · Pace, FLN9837LIal Corp · Wilmington, DEN9837TSmith Robert M III · Taft, CAN98381Central Air Parts Inc · Staunton, ILN9838BJacks Charles D · Morse, LAN9838CWellman A Ryan · San Jose, CAN9838GMcdonald James E · Harleyville, SCN9838HBaeder Mark A · Mesa, AZN9838VWaypoint Equipment LLC · Mckinney, TXN98395Dury Aviation Services Inc · De Soto, ILN9839GLong William F · Belton, TXN9839JDarling Dudley W · Northborough, MAN983AWGuthrie Robert Paul · Joiner, ARN983VBKaufman Jeffrey Robert · Chapel Hill, NCN98407Choice Aviation LLC · Hamilton, MTN9840ABrentco Aerial Patrol Inc · Canton, OHN9840CMid Atlantic Ag LLC · Nassau, DEN9840ELjmf17 LLC · Hayes, KSN9840JBean James P · Tulsa, OKN98410Mbk Leasing And Consulting LLC · Lakeland, FLN9841GYoxall Jennifer S · Guilford, CTN9841HItd Services LLC · Clarendon, TXN9841LHalsmer Ann Lucille · Lafayette, INN9841YBaker Joseph M Trustee · Overland Park, KSN98424Pfister Thomas K · Minneapolis, MNN98426Civil Air Patrol · Maxwell Afb, ALN98428T&W Aviation LLC · Pinehurst, TXN9842CSale Reported · Belgrade, MTSale reportedN9842ESopko Michael C · Bonita, CAN9842GNighthawk N8231g LLC · Pompano Beach, FLN9842HStewart John D · Slatington, PAN9843HAircraft Guaranty Corp Trustee · Oklahoma City, OKN9843TPrzygoda Raymond C · Pinckneyville, ILN9843VAnderson Erik H · Trinity Center, CAN9843XTidwell Gregery D · Modesto, CAN9843YCavu Solutions LLC · Renton, WAN9844BRegistration Pending · Mount Pleasant, UTRegistration pendingN9844EKcsi Aerial Patrol Inc · Bakersfield, CAN9844VKorte Daniel J · Marlette, MIN98456Civil Air Patrol Inc · Maxwell Afb, ALN9845HAaa Sales LLC · Apple Valley, MN
Back to AD 87-20-03 R2