AD 74-18-13
Registered aircraft · 1,642
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:74-18-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
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:74-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13') 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.
N4727SCarlin Delbert J · Blanchard, OKN4728SSam Aviation Corp · Millstadt, ILN4729SKitko Paul D · Cincinnati, OHN472RPWsic LLC · Crosbyton, TXN4740SJeg Air LLC · Monroe, GAN47463Ales Victoria LLC · Elburn, ILN4758SMcdonald Sales & Leasing Inc · Marshville, NCFirst renewal noticeN47593Holthaus Donald H · Fort Loramie, OHN4761SSteed John H · Columbus, GAN47669Registered aircraftN4768SDidier Thomas · Port Washington, WIN47697Andrews Dana C · Granite Bay, CAN4769SRedemption Leasing LLC · Kodiak, AKN4770SGuidry Derrick Jermaine · Lake Charles, LAN4775F2 Fly Aviation LLC · Short Hills, NJN478MAHarpazo Aviation LLC · Lake City, FLN47914Ciolkowski Edward L · Webster, NYN4793SArkansas Pilots For Christ Inc · Paragould, ARN4797SSmith Matthew · Seattle, WAN4798SEller Donald B · Palmer, AKN4799SMiller Charles B · Pass Christian, MSN47GHBrennan William · Bethpage, NYN4800SWaalewyn Tracy W · Clermont, FLN4803SEsmailka Harold E · Ruby, AKN4804TFord Jesse Harrison · Matthews, NCN4806SJohnson Mack W · Guymon, OKN48081Patriot Disaster Specialist LLC · Big Pine Key, FLN4808SAxim Aero LLC · Miami, FLN4810SSt Somewhere Airlines LLC · Destrehan, LAN4811TDill Mark B · Neosho Rapids, KSN4812SEdwards Daniel M · Wendell, NCN4813SWescomp LLC · Kissimmee, FLN4814SRegistered aircraftN4816SYarbrough Clay Alan · Brownsboro, ALN4821S4821s LLC · Ponte Vedra Beach, FLN4822SHolladay Pamela J · Louisville, KYN4823TCrane Kenneth J · Clinton, INN4824SWilly Jack LLC · Wickenburg, AZN4826SQuill Sean · Hadley, MAN4827SMckemy Michael L · Joppa, MDN4828SPuerto Rico Aircraft Leasing Corp · Ceiba, PRN4831SRegistration Pending · Kodiak, AKRegistration pending, pending cancellationN4835SHolder Jamie · Marionville, MON4837SJrf Aircraft LLC · Maple Shade, NJN4838SDairy Air LLC · Lake Jackson, TXN4841SPuerto Rico Aircraft Leasing Corp · Ceiba, PRN4849SCzyszczon Aviation LLC · St Pete Beach, FLN4863SHogs LLC · Georgetown, SCN4865SBowman Steven R · Manteo, NCN486DMMoes Sarah J · Rossford, OH
Back to AD 74-18-13