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.
N890JRFrasch Randy · Missoula, MTN890KCMustang Sally Aviation LLC · Camden, SCN890MAIcarus Flying Academy LLC · Farmingdale, NYN890MBVan Bortel Aircraft Inc · Arlington, TXN890NDUnd Aerospace Foundation · Grand Forks, NDN890SBEason Richard E · Merced, CAN890SCPeregrine Howard Partners II Lp · New Orleans, LAN890TWPlanes & Things Inc · Collinsville, OKN890UBoard Of Regents Of The University Of Oklahoma · Norman, OKN890WTRegistration Pending · San Antonio, TXRegistration pendingN8910CBurns Edward D · Zillah, WAN8910DArmes John W · Elkhorn, WIN8910WAnderson Jeffrey D · Camarillo, CAN89114Drop Table Airplanes LLC · San Anselmo, CAN8911CKing Michael A · Eddyville, IAN8911DPunt Eric · Wasilla, AKN8911FA And J Aviation Services LLC · Titusville, FLN8911VHorizon Dreams LLC · Homer, GAN8911WMonson Horizons Inc · Reynolds, ILN8912DParris Michael D · Rockport, TXFirst renewal noticeN8912FHaddock Richard R · Aiken, SCN8912JSoar With Sophia LLC · South Lyon, MIN8912PPotts John L · Enterprise, ALN8912VRoper Jeff A · Corralitos, CAN8912WHastings David · Lake Havasu City, AZN89132Affiliated Air Services Inc · Southampton, NJN8913CGuess Gerald B · Hernando, FLN8913DBrick H Paul · Pomerene, AZN8913FLay Jerry K · Minonk, ILN8913VI'Ll Fly Away LLC · Florence, SCN8913WMra Aviation Inc · Springfield, VAN8914DPieper Michael D · Chandler, OKN8914JVesper Aviation LLC · Las Vegas, NVN8914RAgaliotis Paul E · San Martin, CAN8914YHarris William M · Christiansburg, VAN89159Napiecek Sarah · Kyle, TXN8915WChandler Forrest J · Cabot, ARN89168Hendrix Walter A · Monroe, GAN8916VTaylor William W Jr · Hudson Oaks, TXN8916YMyers Randall · Parshall, NDN89171Kruzdlo Alan · Calhoun, GAN8917JI Was Inverted LLC · Fort Myers, FLN8917YHigh Flyers Inc · Jackson, TNN89186Hangar 47 Aviation LLC · Midvale, UTN8918DPapalote Ranches LLC · Missoula, MTN8918RDoolittle Philip E · Dunmore, WVN8918YFerucci Paul G · Anchorage, AKN89192Stone Christopher B · High Point, NCN89197Campbell Michael R · Aurora, NEN8919DLuallin Randy D · Hot Springs, SD
Back to AD 81-18-04 R2