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.
N5938YFly For Fun Aircraft LLC · Rockville, MDN5948YFbm LLC · Laporte, INN5955MMonte'S Flying Circus LLC · Wonder Lake, ILN5961YWillis Burlin T · Wasilla, AKN5963YS And S Aviation Consulting · Hampshire, ILN5972YBm Aviation LLC · Vinton, VAN5977YRed State LLC · Daytona Beach, FLN5982YDawkins Karlene A · Coral Springs, FLN5986YBlackhawk Holding Corp · Wilmington, DEN59EEKern Raymond L · Bedford, INN5HMEvans Hayward D · Saint Augustine, FLN600RJRankin Richard · Germantown, TNN6011YTab Associates Inc DBA · Port Saint Lucie, FLN6017YTulsa Technology Center School District No 18 · Tulsa, OKN6030YReddick Brent · Paragould, ARN6034YTan American Corporation · New York, NYRegistration revokedN6039YAllen Aviation Inc · Aynor, SCN6044YPinnock Charles W · Port St Lucie, FLN6046YWells Douglas A · Chino, CAN6052YCentral Kentucky Aviation Inc · Bardstown, KYN6058YEltgroth Peter G · Livermore, CAN6062YJahba LLC · Coral Springs, FLN6069YAngelman Aviation LLC · Prosper, TXN606CACv Wings LLC · Canby, MNN6085YPharmair LLC · Jackson, MSN6089YAerosavant LLC · Towanda, PAN6092YClean Waste Solutions LLC · Indianapolis, INN60LFNorthwoods Air LLC · Orono, MEN60MBCurry Arnold J · Houston, TXN611SGRph Engineering LLC · Lehi, UTN611WWCone S E Jr · Hobbs, NMN6121YWeaver Scott Allen · North Logan, UTN6125YDelaware Aircraft Trust LLC Trustee · New Castle, DEN612EHIsland Flyers Inc · Addison, TXN612MRFladr LLC · Westfield, NJN612WWEhecatl LLC · Fort Wayne, INN613RAKampa Arnold J · Vero Beach, FLN613WKKnaust Jerry L · Blue Jay, CAN6140YSouthern Seaplane Inc · Belle Chasse, LAN6149YRobbins Warren N · Chandler, AZN6164YStriplin James R Jr · Hartford, ALN6169YWiesen Enterprises Ltd · Empire, MIN6170YGe Org Advanced Systems LLC · Newton, NJN6180YChilton Leonard Jay · Caddo Mills, TXN6189YSmith Brian Charles Jr · Lake Mary, FLN6193YMatthews Aviation LLC · Hardinsburg, KYN6198HLane Aviation Inc · Rosenberg, TXN619BLPacific Fleet Aviation LLC · Rochester, NYN61MGDominion Air Charter Inc · Louisa, VAN61NCNorthwest Florida Flight Services LLC · Jacksonville, FL
Back to AD 83-22-01 R1