AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N4893DMazone Robert J · Deer Park, WAN4893ELjl & D Inc · Wilmington, DEN4893GBoldflight LLC · Greenwood, INN4893JMartineau Aircraft Inc · Butte, MTN4893PTri-City Helicopter Services Inc · Richland, WAN4894AHagenston Arthur J · Fairbanks, AKN4894JCapri Blue Aviation LLC · Norcross, GAN4894LPeairs Gregory Ross · Sacramento, CAN4894TBar Aviation LLC · Madison, ALN4895AHigh Exposure Inc · Wilmington, DEN4895DMissouri Aviation Inc · Leeton, MON4895EWestern Big R Inc · Burns, ORN4895GWilson Forest B · Hollister, CAN4895PKlein Barry A · Friday Harbor, WAN4895SFoster Bryan A · Malabar, FLN4895VEbrite Richard P · Long Beach, MSN4895YKeating George W · Fayetteville, ARN48966Kapellair LLC · Wickenburg, AZN4896CFlying Paws LLC · Arvada, CON4896DBrown Jason · Edwards, CON4896EMcgrail Stephen M · South Dennis, MAN4896FPorter Carl S · Seymour, TXN4896GGecha Richard Mike · Florence, VTN4896JMyshatyn Michael · Eaton, CON4896KBraxtal LLC · Kingfisher, OKN4896LMike Delta Kilo LLC · Bentonville, ARN4896MSmtm Holdings Inc · Wilmington, DEN4896QBecker Flying Service Inc · Hartington, NEN4896RB&R Aerial Crop Care Inc · Connell, WAN4896TVosler Dean S · Bay City, MIN4896VSouth Aero LLC · Albuquerque, NMN4897DHall Leah · Diamond Springs, CAN4897ESig Flights LLC · Hickory, NCN4897FGnl Aviation LLC · Weatherford, OKFirst renewal noticeN4897GWings Over Texas Holdings LLC · Denton, TXN4897YKnutson Wayne R · Tioga, NDN4898CPalo Aerocraft Inc · Salem, VAN4898DAcute Holdings LLC · Jenks, OKN4898FLima-001 LLC · Muscatine, IAN4898QTaylor Aviation Inc · Fort Benton, MTN4898WSorce Angelo J · Dandridge, TNN4898YSimmons Mark Adba · Pawcatuck, CTN4899GJf Property Leasing Inc · Port Orchard, WAN4899LSweat Larry D · Meridian, IDN4899PC E S Corporation · Charleston, WVRevoked, canceledN489ACKuza Flyers LLC · Rock Hill, SCN489ALHehl Adam D · Anchorage, AKN489BCAviation Services Inc · Barre, VTN489BJNo Air Services LLC · Holbrook, NYN489CDFrg Aircraft Partnership LLC · Barefoot Beach, FL
Back to AD 2007-04-19 R1