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.
N7125LCulbertson Lloyd K · Phillipsburg, KSN7125PHernandez Jimmy Lee · Lamesa, TXN7125QPiedmont Flight Inc · Winston Salem, NCN7125UTakacs Robert S · Oxford, CTN7125VSutphen James A · Henderson, TXN7125WRavelli Sidney · Salem, OHN71266Kuhtenia David G · Galena, OHN7126DKintner Daniel S · Conyers, GAN7126GHenry Rolla G Jr · Saint Charles, MON7126KWaller David · Carthage, MON7126RLeonard Justin P · Charleston, SCN7127BGeorge William A · Denton, TXN7127RGreen William A · Memphis, TNN7127YSpencer Avionics Inc · Spencer, IAN7128GDsr Cherokee 180 LLC · Dallas, TXN7128LUrocopters Inc · Lancaster, CAN7128PRegistered aircraftN7128QAmerican Patrols Inc · Midland, TXN7128URegistration Pending · Billings, MTRegistration pending, canceledN7128VLinville Aero LLC · Chapel Hill, NCN7128WVan Curen Mary Ann · Owasso, OKN7128YAir Mods And Repair Corp · Robbinsville, NJN7129DBusse Charles U · Cary, ILN7129GSmith Lyle D · San Marcos, TXN7129PBachand Cade C · Dickinson, NDN7129QG Alaouie LLC · Port Austin, MIN7129RLinn Stephen K · Evergreen, CON7129YButner Gary W · Yuba City, CAN7129ZBlue Ridge Soaring Society Inc · New Castle, VAN712DAlpha Aviation LLC · Dalhart, TXN712DMFox Dennis C · Oklahoma City, OKN712DTBrown Charles A · Boise, IDN712EREmbry-Riddle Aeronautical University Inc · Prescott, AZN712GWArmstrong Michael L · Bend, ORFirst renewal noticeN712JGBirdsong Brad · Lubbock, TXN712JTSkylens LLC · Hammond, LAN712LDia Development LLC · Mesa, AZN712LDBurns William J · Onalaska, WIN712LULiberty University School Of Aeronautics · Lynchburg, VAN712MDMosley Daniel J · Jackson, MSN712MSNational Aircraft Leasing · Greenville, DEN712NVEpic Aviation Enterprises LLC · Austin, TXN712PJason Schwitters Farm Inc · Clara City, MNN712RFix Wing LLC · Fort Lauderdale, FLN712RFFleming Ray J · Duson, LAN712SPAmeriflyers Of Texas Inc · Addison, TXN712TMHudson Valley Helicopter Flight Services LLC · Salt Point, NYN712TTAb Cessna LLC · Wilmington, NCN712UTumbleweed Leasing Co Inc · Salt Lake City, UTN712WHWhiskey Hotel LLC · Marengo, IL
Back to AD 81-18-04 R2