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.
N4870TBailey Charles G · Phoenix, MDN4871SLaingkids LLC · Lewes, DEN4872SBlocker James Deric · Cave Creek, AZN4874SShores Financial LLC · Thayer, ILN4876SLedford Roland S · Borger, TXN4877SRegistered aircraftN4878SGarmin International Inc · Salem, ORN4879SWilliams Michael J · Mount Laurel, NJN4881SGuerin Brian J · Walnut Creek, CAN4883SKipp Thomas H · Chardon, OHN4884SLeto Aviation LLC · Delaware, OHN4885SEm & Rb Aviation Group LLC · Tampa, FLN4886SW & K Enterprise LLC · Lewisville, TXFirst renewal noticeN4887SSlater Michael C · Stillmore, GAN4889STiger Wings LLC · Hoover, ALN4892SF&G Polk Aviation LLC · Babson Park, FLN4895SFoster Bryan A · Malabar, FLN48VZPrecision Jet Service Inc · Stuart, FLN4907FVirginia Cherokee LLC · Leesburg, VAN492AGBounds Lee S · Pflugerville, TXN493CAMccann James M · Ennis, MTN4960FLc Aviation LLC · Fort Meade, FLN49SFBcr Aviation LLC · Chantilly, VAN5014SGandy Austin T · Channelview, TXN5014TGalati David R · Sebring, FLN511AGIc Johnson LLC · Belton, SCN514CMHoward Darrell C · Lafayette, LAN518DPN518dp LLC · Spruce Pine, NCN5201SVancuren Maryann · Owasso, OKN5202SWilliams Christopher Lee · Wallingford, KYN5205SAgrivation LLC · Indianola, IAN5207SOhio Air Enterprises LLC · Lancaster, OHN520JWHangar 6 LLC · Saint Augustine, FLN5215SFive Generation Flyers LLC · Melbourne, FLN5216SSale Reported · Spearfish, SDSale reportedN5221S3a LLC · Trussville, ALN5229SInk International Inc · Lawrenceville, GAN523CDOswald Brandon M · Chesapeake, VAN5242STanakon Inc · Fairbanks, AKN5246SPapa Kilo Aviation LLC · Palm Beach, FLN5247FBasha Joseph W Jr · Alexandria, LAN5251SHegarty Joseph L · Sioux Falls, SDN5252SFkf LLC · Imperial, NEN5258SPace Aviation LLC · The Woodlands, TXN5259SSquier Robert J · Royal Oak, MIN5262SSalls Robert A · Glen Mills, PAN5263TBackroads Aviation LLC · Holdrege, NEN5265SEagle Aeronautics LLC · Chicago, ILN5295THayley Douglas Aviation Inc · Auburn, ALFirst renewal noticeN533TRiser LLC · Wimberley, TX
Back to AD 74-18-13