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.
N6205YMarschke Corey A · Stevens Point, WIN6219YTab Associates Inc DBA · Port Saint Lucie, FLN622KCarr Randal J · Chandler, OKN622TBPacific Fleet Aviation LLC · Rochester, NYN6230YRegistration Pending · Chapmansboro, TNRegistration pendingN6235YBeaver Douglas G · Harleysville, PAN6238YBarding Steven P · Hogansville, GAN62494Pacific Fleet Aviation LLC · Rochester, NYN62495Gentrys Flying Service LLC · Prattville, ALN62498Hogan Michael J · Bonita Springs, FLN6249YPapagni Demetrio G · Madera, CAN62508Pacific Fleet Aviation LLC · Rochester, NYN6253YMidwest Air LLC · Hartford, SDN62553Pacific Fleet Aviation LLC · Rochester, NYN62557Yukon Intermountain Inc · Anchorage, AKN62564Del Mar College · Corpus Christi, TXN6257HFinck Michael · Port Charlotte, FLN6257YDavila Rudolfo G · Runge, TXN62593Samco USA LLC · Reno, NVN62599Raw Enterprises Inc · Lewes, DEN62607Horizon Aeronautics · Columbia, SCN62625Registration Pending · Buffalo, MNRegistration pendingN6262HLle Aire LLC · Cocoa, FLN62641Systir Aviation LLC · Pittsburgh, PAN62647Pacific Fleet Aviation LLC · Rochester, NYN62650Lpc Aviation Inc · Punta Gorda, FLN62654Skylens LLC · Hammond, LAN62665Murvin Theoren J III · Winter Garden, FLN62677Kersey Brian A · Pulaski, TNN62688Blair Leonard · Fleetwood, PAN62697Edwards Benjamin F · La Canada, CAN62699Antelope Valley College · Lancaster, CAN6269YN6269y Six Place LLC · Miami, FLN626BFVenture North Aviation LLC · Cloquet, MNN626SPJoye Robert M · Casa Grande, AZN62707Registration Pending · Piedmont, SCRegistration pendingN62745Pacific Fleet Aviation LLC · Rochester, NYN62756Red State LLC · Daytona Beach, FLN62757Delaware Aircraft Trust LLC Trustee · New Castle, DEN62787Williamsburg Air Service Inc · Kingstree, SCN627JKUlrich Sandy J · Haskell, OKN62801Pacific Fleet Aviation LLC · Rochester, NYN62802Hannair LLC · Titusville, FLN62804Hill Adam John · Bethlehem, GAN62807Neal Aircraft Inc · Slaton, TXN62808Wings Over Texas Holdings LLC · Denton, TXN6280YJ & S Of Wi LLC · Iola, WIN62812Facer Insurance Agency Inc · Rantoul, ILN62818Pollack Matthew · Falls Church, VAN62823Mcmillan William K · Jamestown, ND
Back to AD 83-22-01 R1