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.
N5851UFoothill Aircraft Sales & Service Inc · Upland, CAN5851VMcconnell Thomas E · Grass Valley, CAN5851WCameron Hugh R · Gainesboro, TNN5851ZBurklund Joel H · Minneapolis, MNN5852HKelley Don Lee · Loon Lake, WAN5852LOhser David G · Hudson, FLN5852QOldham Jared K · Richfield, WIN5852WFerguson Carl R · Waupaca, WIN5852ZTuttle James R · Cherryvale, KSN5853DHapka Leon J · Halma, MNN5853LKennedy Samuel E · Watsonville, CAN5853PLewellen Walter G · Moreno Valley, CAN5853UPost Jay M · Greenfield, OHN5854DPro West Air LLC · West Point, UTN5854LVolpe Brandon M · Baton Rouge, LAN5854NShort Brian D · Rock Island, ILN5854UMagic Valley Aero Club Inc · Twin Falls, IDN5854WAtluas LLC · Dallas, TXN5855DMiller Justin · Boaz, ALN5855HNortheast Cub LLC · Hudson, NYN5855LSchauf Cindy R · Colwich, KSN5855WZachry David · West Point, GAN5856DStephen George · Land O Lakes, WIN5856HWaco West Inc · Dover, DEFirst renewal noticeN5856LOrland Flying Service Inc · Bunnell, FLN5856PDemontalvo Aaron M · Mansfield, TXN5856QDison Timothy A · Nolensville, TNN5856WSergeant Mary E · Harvard, ILN5856ZHankins Jon A · Fort Mohave, AZN5857LHill James III · Gainesville, FLN5857VHague Parkerson B · Virginia Beach, VAN5858HKoch Michael R · Nemo, SDN5858WPaulisin George W · Crossville, TNN5859NPegasus Flight LLC · Carbondale, ILN5859PSnider Scott E · Turner, MTN5859QHill Larry J · Idaho Falls, IDN5859VHaney Paul · Navarre, FLN5859ZInternational Air Services Inc Trustee · Carson City, NVN585AMPj Aviation LLC · Richmond Hill, GAN585AWChristiansen Aviation LLC · Wilmington, DEN585CAThomas-Guy Ltd · Newtown, PAN585CBBlack Christopher · Williamson, NYN585CCUsda-Aphis-Ws · Cedar City, UTN585CPCivil Air Patrol · Maxwell Afb, ALN585DEHouston Fire Aviators LLC · Houston, TXN585GEWayne Mogg Inc · Parker, AZFirst renewal noticeN585LJWaldal Art B · Battle Ground, WAN585MAPadawan Labs LLC · Portland, ORN585MRCooper Marcus F III · Locust Grove, GAN585NYPacific Fleet Aviation LLC · Rochester, NY
Back to AD 81-18-04 R2