AD 83-22-01 R1
Registered aircraft · 924
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:83-22-01-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:83-22-01-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:83-22-01-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:83-22-01-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.
N78GSAir Mods And Repair Corp · Robbinsville, NJN78JT71793 LLC · San Luis Obispo, CAN78LJValiair Lc · Casper, WYN790BBBeitel Robert R · Lake Wylie, SCN796AATechnical Education Services Inc · Virginia Beach, VAN797VCSantana Carlos A · San Juan, PRN79HLIndiana Paging Network Inc · Laporte, INN79MFSkyking Aviation Services LLC · Carson City, NVN7AZDevaney Aviation Inc · Palm City, FLN7CBExperimental Aircraft Association · Oshkosh, WIN7HWAltieri Frank J · Somerton, AZN8006JCrimson Star LLC · Virginia Beach, VAN8050YGmm Records · Big Pine Key, FLN806RRIsland Flights Inc · Wilmington, DEN8075RTahoe Creations Inc · Zephyr Cove, NVN80FFP A M Aviation LLC · Portsmouth, NHN8124YMatthews Grover C · Hardinsburg, KYN81615Heyl Holdings LLC · Orlando, FLN817JBBenham James M · College Station, TXN818CCFlyit LLC · Camas, WAN8247GCity Of Stuttgart · Stuttgart, ARN827ECPacific Fleet Aviation LLC · Rochester, NYN82BLSkylens LLC · Hammond, LAN837HBKellum Mark · Belden, MSN83BFHayssen Arthur H · Sebastopol, CAN83JWCarpe Diem Aviation LLC · Cleveland Heights, OHN83MHStich Michael A · Malvern, OHN83WCRegistered aircraftN8595BGreene County Vocational School District · Xenia, OHN85RJTechnical Education Services Inc · Virginia Beach, VAN867DCAir Enterprises LLC · Dover, DEN87AJdkracl Aircraft LLC · Gretna, NEN888PEPacific Flight Academy LLC · Honolulu, HIN888RJMongini David · Cottonwood, AZN888TGSkylens LLC · Hammond, LAN888WPVantage Point Aviation LLC · Ormond Beach, FLN88NPRegistration Pending · Saint Petersburg, FLRegistration pendingN88PZ88pz LLC · Clifton Park, NYN88SHSmith Jeary K · Greenfield, INN88VBBjelland Richard A · Galt, CAN89BRN89br LLC · Wilmington, DEN89VVAdams Aviation Services Inc Trustee · Wilmington, DEN8APMatthews Aviation LLC · Hardinsburg, KYN8CTOpitz Airways Inc · Belleair, FLN900AMGimli Son LLC · Fort Lauderdale, FLN900TSMidwest Flying Service Inc · Sheldon, IAN900WWBucher Burton · North Chicago, ILN901APEvanson Scot A · Monroe, TNFirst renewal noticeN901VWAviation Business Corp · Saint Louis, MON90253Wood Roger Weaver · Sale Creek, TN
Back to AD 83-22-01 R1