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.
N99750Kool Wings Leasing LLC · Indianapolis, INN99759Civil Air Patrol · Maxwell Afb, ALN9975LSass Ryan E · Pleasanton, CAN9975WPoole Terrell W · Rigby, IDN99765Tactical Intergriated Training Solutions LLC · Colorado Springs, CON99767Puryear John · Graham, TXN9976DHamon Troy R · King Salmon, AKN9976TAlvarez Humberto H · Kingsville, TXN99770Civil Air Patrol · Maxwell Afb, ALN9977CSchuster Jacob M · Mchenry, ILN9977DMesserla David M · Manhattan, KSN9977VLunceford James A · Stanchfield, MNN9977WN9977w LLC · Easley, SCN9977YBenninger Timothy A · Cobleskill, NYN99783Alexander Todd · Westhampton, MAN9978RButts James A · Gainesville, GAN9978TMaletich Dustin S · Pilot Rock, ORN9979CVan Lehn Sethany A · Frederick, MDN9979UBest David E · Newalla, OKN997ABarlett Jeffrey H · Mentor, OHN997ABBentrup Reinhard F · Goleta, CAN997CCWunorse Openslae LLC · Dallas, TXN997CPCivil Air Patrol · Maxwell Afb, ALN997CWDanesy Dorothea H · Pasadena, CAN997CZClark James S IV · Bristow, VAN997DDark Horse Express LLC · Hendersonville, TNN997FGFlightgest Academy LLC · Morrisville, NCN997GWWoodward Mark J · Bellingham, WAN997HPWard James P · San Jose, CAN997MCAeroventures Flying Club Inc · Lilburn, GAN997NCVega Gustavo E · Watertown, NYN997RAAtp Aircraft 4 LLC · Wilmington, DEN997REEuroaviation Inc Trustee · KematenN997SEAero Equities LLC · Ventura, CAN997SGRas Aviation LLC · Elyria, OHN997SUSouthern Utah University · Cedar City, UTN997UPPotti Noah · Kalispell, MTN997VBBrandon Greg V · Georgetown, TXN997WTRxy LLC · Gilbert, AZN9980LJenkins Allyn Terry · Boynton Beach, FLN9980WAll American Aviation Services Inc · Fayetteville, NCN9981RMatthias Robert C · Gainesville, FLN9981TLadegard Paul E · Wasilla, AKN9981UExpedition Air LLC · Antioch, CAN9981VWeeks Richard F Jr · Portsmouth, NHFirst renewal noticeN99826Cp Aviation · Santa Paula, CAN9982LCarter Robert J Jr · Oak Ridge, TNN99832Watch Ya Head Aviation 1 LLC · Zionsville, INN9983PTaf Aerial Services LLC · Beeville, TXN9983VHeyman William L · Santa Fe, NM
Back to AD 81-18-04 R2