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.
N55094Remedy Aviation LLC · Langford, SDN55096Robinson Jeffrey M · Scottsboro, ALN5509FAhs Aero LLC · Leo, INN5509JJet Air Inc · Iowa City, IAN5509QCarlson Jeremy Nathaniel · Arnold, CAN5509WKitts John L · New Braunfels, TXN550DBHarding Mason · Phoenix, AZN550DEJanay Jesse A · Charlottesville, VAN550EEEidal Peter M · Kent, WAN550ERCoco Aircraft Inc · Merritt Island, FLN550FLKennedy Adam B · Des Moines, WAN550JSBawk Aviation LLC · Xenia, OHN550LAOscar Tango LLC · Mesa, AZN550NDPhoenix East Aviation LLC · Daytona Beach, FLN550PWhitmus Christopher A · Bowie, TXN550PEHeller Ross S · Gig Harbor, WAN550PUSkyborne Airline Academy Inc · Vero Beach, FLN550WHAlligator Inc · Lawrence, KSN5510FHughes Arlen L · Saratoga, WYN5510QN407ml LLC · Wilmington, DEN5510WMilius Douglas L · Oshkosh, WIN55115Gleason Ronald L · Willows, CAN55116Stick And Rudder Aviation LLC · Hale, MON55117Smathers Jason R · Redwood City, CAN5511ABuller Paul W · Laguna Hills, CAN5511FSmith Jimmy A Jr · Albemarle, NCN5511GQualitair LLC Trustee · MichelstadtN5511PGear Down Hangar LLC · Phoenix, AZN5511QJohnston Evan · Yakima, WAN55121Lifetime Adventures LLC · Bellevue, MIN55124Stroud Stephen D · Independence, MON55126Zing Aviation And Marine LLC · New Smyrna Beach, FLFirst renewal noticeN55127Lands James M · Stoutsville, OHN55129Bauer Roger · Saint Germain, WIN5512CGayle William G · Harpersville, ALN5512FWestergaard Wayne B · Craig, NEN5512JWhitaker Robbie L · Brooklet, GAN5512URegistration Pending · Smiths Station, ALRegistration pendingN5512VCabaniss Tex P Jr · Cypress, TXN5512WMoy Jack M · Los Angeles, CAN5512ZShadow Aviation Inc · Fairbanks, AKN55131Sansone Gary A · Fort Laramie, WYN55134Xin Han Aviation LLC · Atwater, CAN55135Air Ventures Flying School LLC · Smithfield, RIN55136Alberio Angela E · Bloomington, MNN55139Hanson Mark A · Snelling, CAN5513LCandice Alarned Enterprises Inc · Long Beach, CAN5513UShi Yi · Walnut, CAN5513WJohnson Thomas D · Pilot Mountain, NCN55140Di Giorgio Thomas J Jr · Lopez Island, WA
Back to AD 81-18-04 R2