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.
N8492BEmery Richard G · Argyle, TXN8492FVintage Wings Aircraft LLC · Centerpoint, INN8492LCarey Thomas A · Carabaset Vly, MEN8492PKovacevich Rudy · Fowler, OHN8492WMoore Myron Keith · Amarillo, TXN8492YGaipa Timothy A · Saint Joseph, MIN84938Shearer Don E · Madrid, IAN8493FCharles City Aeronautics Inc · Charles City, IAN8493LBriss David S Dmd · Somerset, NJN8493RCapital City Flyers LLC · Thomasville, GAN8494DKincaid Jonathan A · Frankfort, MEN8494FPlane Viewing LLC · Colbert, WAN8494LHess Garrett · Fullerton, CAN8494RCactus Air Gold LLC · Mesa, AZN8495FKing Robert M · Fall River Mills, CAN8495WSensenig Landis · Owen, WIN8496FSoriano Juan H · Travelers Rest, SCN8496WKnapp Richard M · Dallas, TXN8496YOsiol Russell E · Chicago, ILN8497WAndrews James E Jr · Cantonment, FLN8498CAir Margarita · San Juan, PRN8498DBig Boy Business LLC · Oklahoma City, OKN8498LWestern Slope Aviators LLC · Delta, CON8498RLangeland Carrol · Menno, SDN8498WPetry Scott A · Greenfield, INN8498YHaigh Joseph C · Rocky Ford, GAN8499BJackson Paul Douglas · Chesapeake, VAN8499DHolton Randall B · Folley Beach, SCN8499FArrow Inc · Rockford, MIN8499LKennedy Christopher S · Canton, ILN8499RZoss Curtis · Pensacola, FLN8499WNazif Ziad J · Denver, NCN8499YKitchen Phillip L · Waterloo, ILFirst renewal noticeN849AScharf Mark T · Rosamond, CAN849AAAb Prop Plane I LLC · Metairie, LAN849ATAtp Taa LLC · Wilmington, DEN849BTPeacock Group LLC · Clermont, FLN849CPCivil Air Patrol · Maxwell Afb, ALN849GSEskridge William · Cheraw, SCN849JBeam Jeffrey W · Arkansas City, KSN849KBoard Of Trustees Of Southern Illinois University · Carbondale, ILN849KSKansas State University · Salina, KSN849PAChristiansen Aviation LLC · Wilmington, DEN849WYYerxa W A DBA · Colusa, CAN84AMoss G B · Bakersfield, CAN84ABBald Eagle Aero LLC · Chesapeake, VAN84AGHillman William W · Oro Valley, AZN84AJPa-18 LLC · South Portland, MEN84ATJ Squared Enterprises Corp · Hendersonville, TNN84AVSyracuse Flying Club Inc · Fayetteville, NY
Back to AD 81-18-04 R2