AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.
N6629WWilcox Chris M · Canajoharie, NYN662APiper Archer Three LLC · Wilmington, DEN662BFFoster Robert B · Erie, PAN662CPCivil Air Patrol · Maxwell Afb, ALN662EREmbry-Riddle Aeronautical University Inc · Prescott, AZN662EZRegistered aircraftN662FLane Bruce · Midlothian, VAN662KKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN662MTMiddle Tennessee State University · Murfreesboro, TNN662NDUnd Aerospace Foundation · Grand Forks, NDN662RFJdm Aero LLC · Pearland, TXN662RSBender Jeff L · Canal Winchester, OHN662SPCessna N662sp LLC · Duluth, GAN662TSchoch Michael Pa · Punta Gorda, FLN662TFAir Fleet Holdings LLC · Missoula, MTN66301Guidry David Brian · Lake Charles, LAFirst renewal noticeN6630AIndigo Associates Ltd · Las Vegas, NVN6630PSumners Toby · Aurora, MON6630RGamma2 Inc · San Diego, CAN6630TRoberts Joshua E · Pike Road, ALN6630UBartholow Paul V · Santa Rosa, CAN6630WRiggin Flight Service Inc · Madison, SDN66313Brazon Brian D · Belle Vernon, PAN6631UMitchell Caleb C · Hebron, NEN6631WRegistration Pending · Arbela, MORegistration pendingN6631ZClark Ryan D · Sequim, WAN6632GGrayson Robert E · Great Falls, MTN6632JSo Cal Leasing LLC · El Cajon, CAN6632LSouthern Aircraft Consultancy Inc Trustee · Casper, WYN6632ZFranconia Soaring Association · Franconia, NHN66337Bales Robert · Osage Beach, MON66339Ave Marina Aviation Co · Long Beach, CANon-citizen corporation, flight hours not reportedN6633FRegistration Pending · Moses Lake, WARegistration pendingN6633JBailey Randall D · Oakley, MIN6633PSkinner Norman D · Osceola, IAN6633RBlake Anthony B · Hallsville, TXN6633WSyf LLC · Okmulgee, OKN66340Wickline Wayne · Flower Mound, TXN66344Sallee Philip L · Yucca Valley, CAN6634BAri Ben Aviator Inc · Fort Pierce, FLN6634JMaier Robert B · Duncanville, TXN6634UC A F E Aviation LLC · Gregory, SDN66352Seaplane Adventures LLC · Cheyenne, WYN66354Chesson Bradley S · Tacoma, WAN6635BChandler Jerome P · Redondo Beach, CAN6635DGooderum Mark P · Excelsior, MNN6635JIndian Head Flying Club LLC · Indian Head, MDN6635PJohnston Robert J · Oro Valley, AZN6635UBistline Ladell J Sr · Colorado City, AZN6636DAnderson James M · Little Rock, AR
Back to AD 81-18-04 R2