AD 72-22-01
Registered aircraft · 11,061
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:72-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-22-01')
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:72-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-22-01') 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.
N1071TChambliss Aviation Services LLC · Greer, SCN1071WPcs Air LLC · Middletown, PAN1072FGeorgia Air LLC · St Simons Island, GAN1074WDreamweaver Aviation LLC · Citra, FLN1077B85 Alpha Inc · Wilmington, DEN1077WPrewitt Russell · Statham, GAN107HMission Accomplished LLC · Boca Raton, FLN107JSSayers James B · Edison, OHN107LULynn University Inc · Boca Raton, FLN107MMBonanza Aviation LLC · Tulsa, OKN107VWHenning Nancy E · Hardinsburg, KYN1080WParks Robert Steven · Hayward, CAFirst renewal noticeN1081YWc LLC · Austin, TXN1088LLima Whiskey Ic LLC · Mertzon, TXN1089CRegistered aircraftN1089EAml Aviation LLC · Lexington, KYN1089WKucera Christopher T · King George, VAN108BCaturia Jeffrey T · Layton, UTN108GBLooney Jordan · Trumann, ARN108JHInternational Air Services Inc Trustee · Carson City, NVN108JTPierobon Patricia · Port Orange, FLN108RKBarnard Brian D · Tallahassee, FLN1091GUnderwood Mold Co Inc · Woodstock, GAN1092WAmerican Aviation LLC · Waterville, MEN1092YCbg Properties LLC · Madison, MSN1094WPolhemus Paul L Jr · Lodi, CAN1095ATychsen Scott E Trustee · Horse Shoe, NCN1097GAos Aviation LLC · Baton Rouge, LAN1097WFred Wacker Agency Inc · Miles City, MTN1097ZIndian Sky LLC · Bossier City, LAN1098WB & G Aviation LLC · Virginia Beach, VAN1099AFritz William · Franklin, PAN1099WTop Hand Inc · Laurel, MTN109AFD&D Aviation LLC · Weatherford, TXN109AKHarris Eric W Jr · Moncks Corner, SCN109BABall Edward C II · Valley Center, CAN109EADegiarde Robert P · New York, NYN109LLLewis & Lewis Equipment LLC · Dodge City, KSN109MLJerry Luttrell And Associates Inc · Kearney, MON109QShariff Diane · Cameron Park, CAN109TYFly Wide LLC · Lewes, DEN109VKeeling Rodney E · Pearce, AZN10AKCygnus Holdings LLC · Ballwin, MON10BPPeyton James L II · Granby, CON10BSB R S Leasing Inc · Wilmington, DEN10BVZondlo Todd · Phoenix, AZN10EEBucci Dennis · Pittsburgh, PAN10EVCafiero Vincent · Haskell, OKN10LFive States Holdings LLC · Helena, MTN10MNAircraft Sales Of America LLC · Fenton, MIFirst renewal notice
Back to AD 72-22-01